#

| Chapter 5 PL/Vision Package Specifications |

## 5.4 PLVcase: PL/SQL Code Conversion

The PLVcase (PL/Vision CASE) package converts the case of PL/SQL source code so that it conforms to the UPPER-lower method (reserved words in upper-case, application-specific identifiers in lower-case). See Chapter 18, PLVcase and PLVcat: Converting and Analyzing PL/SQL Code for details.

### 5.4.1 Package constants

`c_usecor CONSTANT VARCHAR2(3) := 'COR';`

  The constant used in calls to module (see below) to indicate that a CREATE OR REPLACE should be appended to the source code for the program unit.

`c_nousecor CONSTANT VARCHAR2(4) := 'NCOR';`

  The constant used to tell module to not append the CREATE OR REPLACE to the program unit.

### 5.4.2 Case-converting programs

`FUNCTION token (token_in IN VARCHAR2, pkg_in IN VARCHAR2 := NULL)`
`RETURN VARCHAR2;`

  Converts the case of a single token according to the UPPER-lower method.

`PROCEDURE line`
`(line_in IN OUT PLVio.line_type,`
`line_out IN OUT PLVio.line_type,`
`found_out OUT BOOLEAN);`

  Converts the case of a single line of source code according to the UPPER-lower method (it calls `PLVcase.token` for each token in the string).

`FUNCTION string (string_in IN VARCHAR2) RETURN VARCHAR2;`

  Converts the case of a string according to the UPPER-lower method. It formats the string as necessary for a call to the `PLVcase.line` procedure.

`PROCEDURE string (string_inout IN OUT VARCHAR2);`

  Procedure version of the `string` function. It hands you back your own `string` variable with the case of the tokens converted.

`PROCEDURE module`
`(module_in IN VARCHAR2,`
`cor_in IN VARCHAR2 := c_usecor,`
`last_module_in IN BOOLEAN := TRUE);`

  Converts the case of a single program unit according to the UPPER-lower method.

`PROCEDURE modules (module_spec_in IN VARCHAR2 := NULL);`

  Converts the case of multiple program units according to the UPPER-lower method.

5.3 PLV: Top-Level Constants and Functions |  | 5.5 PLVcat: PL/SQL Code Cataloguing

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