How to encrypt triggers, stored procedures and functions ?

chkbelg used Ask the Experts™
is there a way to encrypt the source code of triggers, stored procedures and function to be viewed by a nother users ?
thanx EE.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

To encrypt packages, procedures, functions and types you can use wrap utility (described in PL/SQL manual). It does not however work on triggers. But if your trigger calls wrapped procedure it will still be unreadable to a user.

It is as simple as (from sqlplus, omit the host if you run from command line)
NOTE: Leave no space around the equal signs because spaces delimit individual arguments.

My procedure name is test.sql

host wrap iname=test.sql oname=test_WRAP.sql

then to compile



thanx EE for your comments.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial