Oracle Database 11g PL/SQL Programming Workbook

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 ...