home | O'Reilly's CD bookshelfs | FreeBSD | Linux | Cisco | Cisco Exam    

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.


Previous: 5.4 PLVcase: PL/SQL Code Conversion Advanced Oracle PL/SQL Programming with Packages Next: 5.6 PLVchr: Operations on Single Characters
5.4 PLVcase: PL/SQL Code Conversion Book Index 5.6 PLVchr: Operations on Single Characters

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference










??????????????@Mail.ru