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

Creating a stored program unit

To create a stored (server-side) program unit:

  1. In the Object Navigator, double-click the Database Objects node. If this node is disabled, the Connect dialog box displays so you can establish a database connection.

  2. Expand the subnode that corresponds to the database user name you used to log in to the database to show the PL/SQL Stored Program Units node.

  3. Click the PL/SQL Stored Program Units node, then click the Create button in the toolbar.

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

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

  6. Click OK.

  7. In the Stored PL/SQL Editor, select a database owner name from the Owner list to indicate where the program unit will be stored in the database, then define the PL/SQL for the stored program unit.

Next step

Moving a program unit between client and server

See also

About stored program units

About program units

Creating a local program unit