Previous
Previous 		 Next
Next

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.

Program Unit Arguments

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

To view the PL/SQL Unit Arguments report:

  1. On the Workspace home page, click the SQL Workshop.

  2. Click Utilities.

  3. Click Object Reports.

    The Object Reports page appears.

  4. In the PL/SQL Reports section, click Program Unit Arguments.

  5. To filter a report, enter search criteria in the fields provided or make selections from the lists, and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details.

  6. 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:

  1. On the Workspace home page, click the SQL Workshop.

  2. Click Utilities.

  3. Click Object Reports.

    The Object Reports page appears.

  4. In the PL/SQL Reports section, click Unit Line Counts.

  5. To filter the report, enter an object name and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details.

  6. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.

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:

  1. On the Workspace home page, click the Utilities icon.

  2. Click Object Reports.

    The Object Reports page appears.

  3. In the PL/SQL Reports section, click Search PL/SQL Source Code.

  4. To filter the report:

    1. In From/To Line, enter the range of lines you want to search.

    2. Click Set.

    3. To filter the report, enter an object name and click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details

  5. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.


 Previous
Previous 		 Next
Next