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 reference 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