Name

PLSQL_V2_COMPATIBILITY (Oracle8 Only)

Synopsis

Values:TRUE or FALSE

Default:FALSE

Sets the compatibility level for PL/SQL. If the value of this parameter is FALSE, PL/SQL V2 is not allowed, and V3 behavior is enforced. If it is TRUE, the following PL/SQL V2 behaviors are accepted when running PL/SQL V3:

  • PL/SQL will allow elements of an index table passed in as an IN parameter to be modified or deleted.

  • The PL/SQL compiler will allow OUT parameters to be used in expression contexts in some cases, for example, in dot-qualified names on the right-hand side of assignment statements. This behavior is restricted to fields of OUT parameters that are records, and OUT parameters referenced in the FROM list of a SELECT statement.

  • PL/SQL will allow OUT parameters in the FROM clause of a SELECT list, where their values are read.

  • PL/SQL will allow the passing of an IN argument into another procedure as an OUT. This is restricted to fields of IN parameters that are records.

  • PL/SQL will allow a type to be referenced earlier than its definition in the source.

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial