Application Express User's Guide > Using SQL Utilities > Viewing Object Reports > Viewing PL/SQL Reports
Viewing PL/SQL Reports |
Previous |
Next |
PL/SQL reports enable you to view program unit arguments or unit line counts or search PL/SQL source code.
Topics:
Use the Program Unit Arguments report to view package input and output parameters.
To view the PL/SQL Arguments report:
On the Database Home Page, click the Utilities icon.
Click Object Reports, PL/SQL, and then Program Unit Arguments.
To filter the report, enter a query in Object Name and click Go.
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:
On the Database Home Page, click the Utilities icon.
Click Object Reports, PL/SQL, and then Unit Line Counts.
To filter the report, enter an object name and click Go.
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 Database Home Page, click the Utilities icon.
Click Object Reports, PL/SQL, and then Search PL/SQL Source.
To filter the report:
In Object Name, enter a query.
In Text, enter the PL/SQL code you want to search for.
Click Go.