#

| Chapter 5 PL/Vision Package Specifications |

## 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.

5.4 PLVcase: PL/SQL Code Conversion |  | 5.6 PLVchr: Operations on Single Characters

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