A script-enabled browser is required for this page to function properly.

Creating a Stored Program

To create a Stored Program:

  1. In the Object Navigator, expand the Database Objects node to display the Schema nodes.
  2. Expand a Schema node to display the database objects.
  3. Select the Stored Program Units node and choose Edit | Create.
    The New Program Unit dialog appears.
  4. Specify the program unit name and type of program unit. The type of a program unit can be either procedure, function, package spec or package body.
    The Stored Program Unit Editor appears.
  5. In the Stored Program Unit Editor, define and save the desired program units.

     Note: When you compile a form, menu, or library containing references to stored procedures, functions, or packages, ensure that the stored subprogram to which you make reference exists on the server during compilation.

About Stored Programs

Modifying a Stored Program

Invoking a Stored Program