Using a Sharable PL/SQL Package

In Oracle Life Sciences Data Hub Programs of type PL/SQL or Oracle Report, you can create an instance of a Source Code definition stored in another Program and marked as Sharable.

Your company may have Programs created especially for the purpose of storing sharable PL/SQL packages.

To use a Sharable Source Code definition:

1. In a PL/SQL or Oracle Reports Program, create a secondary Source Code object as an instance of an existing Source Code definition (see Creating an Instance of an Existing Source Code Definition).
2. When you search for the definition source, specify the PL/SQL package storage Program as the Program search criterion.
3. You can select one or more of the PL/SQL packages. The system includes the source code for each package you select in the Source Code instance of your Program.

See Upgrading Source Code And Undoing Source Code Upgrades for information on how to upgrade Source Code instances pointing to a sharable Source Code definition.