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

The PL/SQL Editor Interface

Compile

Compiles the program unit appearing in the Source pane. Any error messages generated as a result of the compilation will appear in the scrollable Compilation messages pane.

Apply

Saves any changes made to the program unit in the editor since it was first opened or since the last apply or revert operation. The program unit is not recompiled. The editor remains open.

Revert

Restores the program unit to its state at the last apply or revert operation. If no apply or revert operations have occurred, the program unit is returned to its original state.

New

Displays the New Program Unit dialog, where you can specify the type and name of the program unit you wish to create.

Delete

Deletes the displayed program unit, with confirmation.

Close

Attempts to close the editor. If any changes have been made but not applied, an alert appears, prompting you to apply or revert the changes or cancel the operation. Once all changes have been applied or reverted, the PL/SQL editor is closed.

Name

Displays the name of the current program unit. Press the arrow to the right of the field to display a drop-down list of other existing program units. Click a program unit on this list to display that program unit in the editor.

In addition, the following elements make up the editor window:

Source pane

Used to enter and edit PL/SQL program unit source text.

Compilation Messages pane

Displays error messages, if any, generated as a result of compilation. Clicking on an error message highlights it, scrolls the Source pane to the offending source statement, and positions the text cursor at the location of the error.

By default, the Compilation messages pane appears only when there are compilation error messages generated. However, you can display the Compilation messages pane at any time by moving the split bar at the bottom right corner of the editor.

Split bar

Enables you to change the relative amount of space occupied by the two panes (source and compilation messages) in the PL/SQL editor. Note that by default, the Messages compilation pane is displayed only when error messages are generated during compilation.

Status line

Displays information about the current state of the program unit at the bottom of the editor.