PLSQL_V2_COMPATIBILITY

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	ALTER SESSION, ALTER SYSTEM
Range of values	true | false

Note:

1. The PLSQL_V2_COMPATIBILITY parameter is deprecated. It is retained for backward compatibility only.

PL/SQL Version 2 allows some abnormal behavior that Version 8 disallows. If you want to retain that behavior for backward compatibility, set PLSQL_V2_COMPATIBILITY to true. If you set it to false, then PL/SQL Version 8 behavior is enforced and Version 2 behavior is not allowed.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘PLSQL_V2_COMPATIBILITY’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
plsql_v2_compatibility	FALSE	TRUE	TRUE	IMMEDIATE	TRUE		FALSE	PL/SQL version 2.x compatibility flag

Oracle initializatoin parameters