| Copyright © 2003, 2008, Oracle. All rights reserved. |  Previous |
 Next |
Home > Managing Database Objects w... > Managing Procedures > 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 copy the code in this view for use in other tools.
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 copy the code in this view for use in other tools. Actions you can perform in this view include: 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. |