3.9 Managing Procedures
A procedure is a subprogram that performs a specific action. Use Object Browser to view, create, edit, download, and drop procedures.
- Creating a Procedure
Create procedures using Object Browser. - Viewing a Procedure
Select a procedure from the Object Tree and access tabs in the Object Detail View. - Editing a Procedure
Select a procedure from the Object Tree and edit it in the Code tab. - Compiling a Procedure
Select a procedure from the Object Tree and click Save and Compile. - Downloading a Procedure
Select a procedure from the Object Tree and click Download to save it as a file. - Dropping a Procedure
Select a procedure from the Object Tree and click Drop.
Parent topic: Managing Database Objects with Object Browser
3.9.1 Creating a Procedure
Create procedures using Object Browser.
To create a procedure:
Parent topic: Managing Procedures
3.9.2 Viewing a Procedure
Select a procedure from the Object Tree and access tabs in the Object Detail View.
To view a procedure:
- In Object Browser, Object Tree, expand Procedures and select a procedure.
- The Object Detail View appears and displays four tabs:
- Code - Displays the source code for
the procedure. You can edit the source code in this view using a fully
functional Code Editor. Available actions include:
- Download
- Save and Compile
- Drop.
- Refresh
Tip:
To learn more about the Code Editor, see Code Editor in Object Browser. - Dependencies - Displays objects that use (or depend) on the current procedure and objects the procedure depends on. To link to an object, click the object name.
- Errors - Lists errors related to the current procedure.
- Grants - Details of grants for the
current procedure, including privilege, grantee, grantable, grantor, and
object name. Available actions include:
- Grant
- Revoke
- Refresh
- Code - Displays the source code for
the procedure. You can edit the source code in this view using a fully
functional Code Editor. Available actions include:
Parent topic: Managing Procedures
3.9.3 Editing a Procedure
Select a procedure from the Object Tree and edit it in the Code tab.
To edit a procedure:
Parent topic: Managing Procedures
3.9.4 Compiling a Procedure
Select a procedure from the Object Tree and click Save and Compile.
If you edit and make changes to a procedure, you must compile to save your changes.
To compile a procedure:
Parent topic: Managing Procedures
3.9.5 Downloading a Procedure
Select a procedure from the Object Tree and click Download to save it as a file.
To download a procedure:
Parent topic: Managing Procedures
3.9.6 Dropping a Procedure
Select a procedure from the Object Tree and click Drop.
To drop a procedure:
Parent topic: Managing Procedures