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