Browsing a Procedure

Previous
Previous
Next
Next

To browse a procedure:

  1. On the Database Home Page, click the Object Browser icon.

    Object Browser appears.

  2. From the Object list, select Procedures.

  3. 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.

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 copy the code in this view for use in other tools. Actions you can perform in this view include:

  • Edit

  • Compile

  • Download

  • Drop

  • Find

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.