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

Creating a local program unit

To create a local (client side) program unit:

  1. In the Object Navigator, click the Program Units node.

  2. Click the Create button in the toolbar.

  3. In the dialog box, type a name for the program unit in the Name text box.

  4. If your program unit is not a procedure (a PL/SQL subprogram that performs a specified sequence of actions), click one of the following:

    Note: If the radio button is not selected when you click, try clicking a different radio button, then click the desired Type again.

  5. Click OK.

  6. 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

See also

About program units

Creating a stored program unit

Editing a program unit