To create a local (client side) program unit:
In the Object Navigator, click the Program Units node.
Click
in the toolbar.
In the dialog box, type a name for the program unit in the Name text box.
If your program unit is not a procedure (a PL/SQL subprogram that performs a specified sequence of actions), click one of the following:
Function (a PL/SQL subprogram that performs a specified sequence of actions, and then returns a value)
Package Spec (datatypes and subprograms that can be referenced by other program units)
Package Body (implementation of the package, which may include private subprograms and datatypes; optional if the package consists only of declarations)
Note: If the radio button is not selected when you click, try clicking a different radio button, then click the desired Type again.
Click OK.
In the PL/SQL Editor, define the PL/SQL for the program unit.
Next step
Adding a program unit to an open library
Moving a program unit between client and server
Running a program unit in the PL/SQL Interpreter
Creating a stored program unit
Copyright © 1984, 2005, Oracle. All rights reserved.