Wrapping up the PL/SQL stored programs
You do not always want your code to be displayed in clear text to the outside world. The code may contain proprietary information which needs to be guarded from external sources. Or you may simply want your code to be hidden from the end users to avoid any unofficial code modifications. Oracle provides a PL/SQL wrapper utility for hiding your code. The following steps are required to wrap your code:
1. Save your code (procedure, function, or package) in a text file.
2. Wrap the code using the PL/SQL wrapper utility. A wrapped PL/SQL code file is created by the utility.
Save the salary_increment procedure in a text file (say, c:\salary_increment) and invoke the PL/SQL wrapper utility in the operating system as shown in the following screenshot:
You can run the output file (c:\temp\salary_increment_wrapped.sql) as a script in SQL*Plus. For example:
-- Execute the wrapped SQL code
SQL> @c:\temp\salary_increment_wrapped.sql
