Skip to Main Content
Advanced Oracle PL/SQL Programming with Packages
book

Advanced Oracle PL/SQL Programming with Packages

by Steven Feuerstein
October 1996
Intermediate to advanced content levelIntermediate to advanced
687 pages
16h 41m
English
O'Reilly Media, Inc.
Content preview from Advanced Oracle PL/SQL Programming with Packages

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

Michael McLaughlin
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Expert Oracle PL/SQL

Expert Oracle PL/SQL

Ron Hardman, Michael McLaughlin

Publisher Resources

ISBN: 1565922387Supplemental ContentCatalog PageErrata