About Static Reference Source Code

You can write source code (PL/SQL package or SAS format) that is intended for reuse in other Programs.

If that Source Code is located in an installed Program instance—usually because it reads data such as lookup values from an Oracle Life Sciences Data Hub Table instance—you must specify a static reference when you create an instance of the Source Code in another Program.

For example, if you want to supply an Investigator ID and return an Investigator Name, you can do either of the following:

• Create a Table Descriptor in your Program and map it to a Table instance that includes columns for both Investigator ID and Name and reference that Table Descriptor in the Source Code you create for your Program. This method does not involve a static reference Source Code.
• Reference a sharable Source Code in another Program instance whose purpose is to take an Investigator ID and return the corresponding Investigator Name. The Program instance that contains this sharable Source Code must have a Table Descriptor that is mapped to a Table instance that includes columns for both Investigator ID and Name. This is a static reference Source Code.

Note:

Oracle LSH does not support creating a static reference to Source Code contained in a Program instance inside a Report Set.