Skip to Main Content

Items used in PL/SQL

Use the package below to find where Apex items are used in PL/SQL code.
Useful for finding items that have been renamed/removed from the Apex application, but are still referenced in PL/SQL code - in which case the value would be null, possibly resulting in all sorts of strange behaviour.


Usage example, to find all Apex items that are referenced in PL/SQL packages named like PCK% (specification or body), but that do not exist in Apex application ID 25384:

Code

Package

Package
Name
Source

Package Body

Package Body
Name
Source