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

New Program Unit dialog box

The New Program Unit dialog enables you to specify a name and type of program unit to create.

This dialog box contains:

Name

Type the name of the program unit.

Procedure

A PL/SQL subprogram that performs a specified sequence of actions.

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. May include private subprograms and datatypes. Is optional if the package consists only of declarations.

Type Spec

Declares the name, variables (attributes) and member subprograms (methods) for an object type or collection type. This option is enabled only if you are connected to an Oracle database.

Type Body

Implementation of the member methods (functions and procedures) defined in the type specification for an object type. For each method specified in an object type, there must be a corresponding method body. This option is enabled only if you are connected to an Oracle database.

Java Source

A database stored procedure, written in Java, that performs a specified series of actions. This option is enabled only if the ORA_DE_REFLECTION packages are installed in the database.