O'Reilly logo

Oracle Database 11g PL/SQL Programming Workbook by John M. Harper, Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

APPENDIX AWrapping PL/SQL

Oracle 11 g lets you wrap or obfuscate your PL/SQL stored programs. Wrapping your code makes the business logic of your applications encapsulated from prying eyes by hiding the source code. It converts the clear text in the database to an unreadable stream of data. You can obfuscate the clear text by using the command line wrap utility or by calling the CREATE_WRAPPED procedure or WRAP function found in the DBMS_DDL package.

You should wrap only the implementation details. This means you should wrap only functions, procedures, package bodies, and type bodies. You enable developers to use your code by leaving the package specification and type specification. They won’t know how it performs the task, but they’ll know what ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required