5.5. PLVcat: PL/SQL Code Cataloguing
The PLVcat (PL/Vision CATalogue) package catalogues PL/SQL source code so that you can analyze the contents of your program for cross-references, dependencies, and so on. See Chapter 18 for details.
5.5.1. Cataloguing package contents
PROCEDURE module (module_in IN VARCHAR2);
Scans the contents of the specified module (currently only package specifications are supported) and writes the list of its contents to the PLVrfrnc table.
PROCEDURE modules (module_in IN VARCHAR2);
Performs same task as the module procedure, but for multiple program units. You can, in other words, provide an argument for module_in that contains wildcards.
5.5.2. Identifying references in stored code
PROCEDURE refnonkw (module_in IN VARCHAR2);
Scans the contents of the specified program unit and writes to the PLVctlg table all references to non-keyword identifiers.
PROCEDURE refbi (module_in IN VARCHAR2);
Generates the list of builtin functions and packages that are referenced within the specified program unit. This list is then written to the PLVctlg table.
Get Advanced Oracle PL/SQL Programming with Packages now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.