Viewing PL/SQL Reports

Previous
Previous
Next
Next

PL/SQL reports enable you to view program unit arguments or unit line counts or search PL/SQL source code.

Topics:

Viewing Program Unit Arguments

Use the Program Unit Arguments report to view package input and output parameters.

To view the PL/SQL Arguments report:

  1. On the Database Home Page, click the Utilities icon.

  2. Click Object Reports, PL/SQL, and then Program Unit Arguments.

  3. To filter the report, enter a query in Object Name and click Go.

Viewing Unit Line Counts

Use the Unit Line Counts report to view then number of lines of code for each object. Use this report to identify larger PL/SQL program units.

To view the Unit Line Counts report:

  1. On the Database Home Page, click the Utilities icon.

  2. Click Object Reports, PL/SQL, and then Unit Line Counts.

  3. To filter the report, enter an object name and click Go.

Searching PL/SQL Source Code

Use the Search PL/SQL Source code page to search the text within your PL/SQL code. Use this report to find references to tables or functions you might be thinking of deleting. You can also use this page to locate code when you can only recall a code snippet.

To search for PL/SQL source code:

  1. On the Database Home Page, click the Utilities icon.

  2. Click Object Reports, PL/SQL, and then Search PL/SQL Source.

  3. To filter the report:

    1. In Object Name, enter a query.

    2. In Text, enter the PL/SQL code you want to search for.

    3. Click Go.