(c) Nigel Maddocks, 2007
Edit-DB ver 2.05.016, Doc ver 2.05.016
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.
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.
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.
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.