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

About the Stored Program Unit Editor

You can create, edit, and compile the source text for stored procedures from the Stored Program Unit Editor.

Title

The title reflects the Schema and name of the currently displayed Stored Program unit.

New

The New button allows the user to enter the source text for a new program unit. A new program unit is only visible within the Stored Program Unit Editor. New program units are not stored in the database until the first compile operation.

Save

The Save button synchronizes the source text displayed in the editor with the source text stored in the database and compiles the Stored Program unit on the server-side.

Revert

The Revert button discards any changes made in the source text pane and restores the Stored Program unit to its previous state. The restored state is the most recent of the following:

  • after the last navigation to this Stored Program unit or its creation with the New button
  • after the last selection of the Compile button

The Revert button is only enabled when there have been changes to the source text pane since one of the above states.

Drop

The Drop button drops an existing Stored Program unit or aborts the creation of a new one (after seeking confirmation via an alert).

After dropping the Stored Program unit, the editor displays the preceding Stored Program unit in the Name combo box if one exists; otherwise, it displays the next Stored Program unit. If there are no Stored Program units for the current owner, the editor is empty.

The Drop button is enabled only if the Stored Program unit is new or the current user has drop privileges for the currently displayed Stored Program unit.

Close

The Close button closes the Stored Program Unit Editor window. If the source text of the currently displayed Stored Program unit has been modified, the editor presents an Unsaved Changes alert.

Owner Combo Box

The Owner combo box identifies the user who owns the Stored Program unit currently displayed in the editor.

Selecting a new entry in the Owner combo box updates the Name combo box and displays the first Stored Program unit in the Name List (if one exists).

Name Combo Box

The Name combo box displays the name of the currently selected Stored Program unit.

The Name combo box contains the names of all accessible Stored Program units owned by the user currently selected in the Owner combo box. A program unit is accessible if the current user has execute privileges on it.

Selecting a new entry in the Name combo box updates the editor to display the newly selected Stored Program unit. If the source text of the current Stored Program unit has been modified, the editor presents an Unsaved Changes alert.

Source Text Pane

The source text pane displays the source text of the current Stored Program unit. It is editable only if the current user has create privileges for the Stored Program unit; otherwise, it is read-only.

Compilation Message Pane

The Compilation Message pane displays any compilation messages associated with the current Stored Program unit.

Clicking on a compilation message moves the text cursor in the source pane to the line and column associated with the message.

The Compilation Message pane is hidden when the current Stored Program unit has no associated error messages.

Status Bar

The Status Bar displays information about the state of the current Stored Program unit.


About Stored Programs

Creating a Stored Program