Defining PL/SQL Programs

See also Setting Up Oracle SQL Developer or SQL*Plus as an IDE

Note:

Each PL/SQL Source Code definition within a particular Program must have a unique Oracle package name.

This section includes information on:

• Writing Primary Source Code in PL/SQL
  When a Program is executed, the system launches its primary source code file.
• Testing PL/SQL Source Code
  To test PL/SQL code, you must first map the Table Descriptors to the Table instances and check in and install the Program instance and all the Table instances it reads from and writes to.
• 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.
• 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.
• Compiling and Executing a PL/SQL Program
  The system compiles PL/SQL source code when you install the Program instance.
• Manipulating Documents through a PL/SQL Program
  You can write a PL/SQL Program to retrieve BLOBs (binary large objects such as documents created using the Microsoft Office Suite) from the database and use them, for example, as a Planned Output of the Program for inclusion in a Report Set.