2.13 Managing Procedures
A procedure is a subprogram that performs a specific action. You can use Object Browser to view, create, edit, download, and drop procedures.
- Creating a Procedure
Create procedure using Object Browser. - Browsing a Procedure
Select a procedure from the Object Selection pane and view different reports about the procedure. - Reports for Procedures
Alternative views available when viewing a procedure in Object Browser. - Editing a Procedure
When you edit a procedure you can edit the code manually or perform a search and replace. - Compiling a Procedure
If you edit and make changes to a view, you must compile to save your changes. - Downloading a Procedure
Select a procedure from the Object Selection pane and click Download Source to save the current procedure as a file. - Dropping a Procedure
Select a procedure from the Object Selection pane and click Drop.
See Also:
Parent topic: Managing Database Objects with Object Browser
2.13.1 Creating a Procedure
Create procedure using Object Browser.
To create a procedure:
Parent topic: Managing Procedures
2.13.2 Browsing a Procedure
Select a procedure from the Object Selection pane and view different reports about the procedure.
To browse a procedure:
Parent topic: Managing Procedures
2.13.3 Reports for Procedures
Alternative views available when viewing a procedure in Object Browser.
Table 2-8 describes all available reports for procedures.
Table 2-8 Available Views for Procedures
View | Description |
---|---|
Code |
(Default) Displays the source code for the procedure. You can edit the code in this view. Actions you can perform in this view include:
|
Dependencies |
Displays objects that use (or depend) on the current procedure and objects the procedure depends on. |
Errors |
Lists errors related to the current procedure. |
Grants |
Lists details of grants for the current procedure, including privilege, grantee, grantable, grantor, and object name. |
See Also:
Parent topic: Managing Procedures
2.13.4 Editing a Procedure
When you edit a procedure you can edit the code manually or perform a search and replace.
- Editing a Procedure Manually
Select a procedure from the Object Selection pane and click Find or Replace.
Parent topic: Managing Procedures
2.13.4.1 Editing a Procedure Manually
Select a procedure from the Object Selection pane and click Find or Replace.
To edit a procedure manually:
Parent topic: Editing a Procedure
2.13.5 Compiling a Procedure
If you edit and make changes to a view, you must compile to save your changes.
There is no save function because this is just a view of the object within the database.
To compile a procedure:
Parent topic: Managing Procedures
2.13.6 Downloading a Procedure
Select a procedure from the Object Selection pane and click Download Source to save the current procedure as a file.
To download a procedure:
Parent topic: Managing Procedures
2.13.7 Dropping a Procedure
Select a procedure from the Object Selection pane and click Drop.
To drop a procedure:
Parent topic: Managing Procedures