Home > Managing Database Objects w... > Managing Procedures > Browsing a Procedure

Previous

Next

Browsing a Procedure

To browse a procedure:

On the Workspace home page, click SQL Workshop and then Object Browser.

Object Browser appears.
From the Object list, select Procedures.
From the Object Selection pane, select a procedure.

The Code view appears, displaying the source code for the procedure. You can edit the code in this view.

Summary of Available Views

Click the tabs at the top of the page to view different reports about the procedure. Table: Available Views for Procedures describes all available views.

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: Edit Undo Redo Save & Compile Download Source Drop Find & Replace See Also: "Editing a Procedure", "Compiling a Procedure", "Downloading a Procedure", and "Dropping a Procedure"
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.