PL/SQL Reports

Use the PL/SQL reports to view program unit arguments or unit line counts and also to search PL/SQL source code.

Topics:

Program Unit Arguments
Unit Line Counts
Search PL/SQL Source Code

Program Unit Arguments

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

To view the PL/SQL Unit Arguments report:

On the Workspace home page, click the Utilities icon.
Click Object Reports.

The Object Reports page appears.
In the PL/SQL Reports section, click Program Unit Arguments.
To filter the report, enter a query in PL/SQL Package or Program Unit and click Go.
To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.

Unit Line Counts

Use the Unit Line Counts report to view the 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:

On the Workspace home page, click the Utilities icon.
Click Object Reports.

The Object Reports page appears.
In the PL/SQL Reports section, click Unit Line Counts.
To filter the report, enter an object name and click Go.

Search 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:

On the Workspace home page, click the Utilities icon.
Click Object Reports.

The Object Reports page appears.
In the PL/SQL Reports section, click Search PL/SQL Source Code.
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. In From/To Line, enter the range of lines you want to search.
4. Click Go.
To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.