Edit-DB Edit-DB
(c) Nigel Maddocks, 2007
Edit-DB ver 2.05.016, Doc ver 2.05.016

5. Procedures and Functions

To display a list of Procedures or Functions for a particular database or schema (and owner depending on database type), select Procedures or Functions from Object type in the Object-type frame, having ensured that the other selections to the left, labelled Database or Schema (and Owner depending on database type), are completed.

List Procedures
List Functions

The Procedure or Function definition can be displayed by clicking the listed object in the Object-List frame.
n.b. Postgre defines a Procedure as a Function with no return value, and can have multiple functions with the same name differentiated by the parameter list.

Procedure display
Function display

The Procedure or Function can be deleted by pressing the Delete button and confirming.

The Procedure or Function can be edited by pressing the Edit button.

Procedure edit
Function edit

On pressing Update the Procedure or Function definition is updated. If the update fails, then the error message from the database is displayed, and the definition can be further modified.

Note: Oracle will often accept invalid object definitions and only present the problems when the object is used.