Creating a Stored Program
To create a Stored Program:
- In the Object Navigator, expand the Database Objects
node to display the Schema nodes.
- Expand a Schema node to display the database objects.
- Select the Stored Program Units node and choose
Edit | Create.
The New Program Unit dialog appears.
- 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.
- 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.
Related topics
About Stored Programs
Modifying a Stored Program
Invoking a Stored Program