Creating a PL/SQL Package Storage Program

You can create PL/SQL Programs especially for the purpose of containing PL/SQL packages as reusable (sharable) Source Code definitions, so that Definers can more easily find them.

You can group logically related packages in the same container Program.

You can then use these sharable PL/SQL packages in Oracle LSH Programs of type PL/SQL or Oracle Report (see Using a Sharable PL/SQL Package).

To create a storage Program for PL/SQL packages:

1. Create a Program of type PL/SQL. Give it a name and description that describe its purpose, such as "Sharable Demography Subroutines."
2. (Optional) Add a primary Source Code definition of type PL/SQL to test the packages. Set its Sharable flag to No.
3. Add the secondary Source Code definitions you want to share. You can create them and write the code from within the storage Program, or you can copy them from other Programs and paste them into the storage Program. They must all be of type PL/SQL.
4. Check in, install, and test the Program.
5. When you have tested each one, set its Sharable flag to Yes. You can change this setting without checking out the Program definition.