Name

PLSQL_V2_COMPATIBILITY

Synopsis

Value: TRUE | FALSE

Default: FALSE

Dynamic: ALTER SYSTEM, ALTER SESSION

Sets the compatibility level for PL/SQL. If FALSE, PL/SQL Version 8 behavior is enforced and Version 2 behavior is not allowed. If TRUE, then the following PL/SQL Version 2 behaviors are accepted when running PL/SQL Version 8:

  • Allows elements of an index table passed in as an IN parameter to be modified or deleted.

  • Allows OUT parameters to be used in expression contexts in some cases. This behavior is restricted to a few cases: fields of OUT parameters that are records and OUT parameters referenced in the from list of a SELECT statement.

  • Allows OUT parameters in the FROM clause of a select list, where their values are read.

  • Allows the passing of an IN parameter into another procedure as an OUT parameter restricted to fields of IN parameters that are records.

  • Allows a type to be referenced earlier than its definition in the source.

Get Oracle in a Nutshell 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