READ_ISOLATION_LEVEL=

READ_ISOLATION_LEVEL=

Specifies which isolation level to use when reading ORACLE tables and views.

Default value: Defaults to the value of the LIBNAME option.

Syntax
Details

Syntax

READ_ISOLATION_LEVEL=READCOMMITTED | SERIALIZABLE

READCOMMITTED: instructs SAS to use the read committed isolation level when reading ORACLE tables.
SERIALIZABLE: instructs SAS to use the serializable isolation level when reading ORACLE tables.

Details

The SPOOL= option overrides the READ_ISOLATION_LEVEL= option. The ORACLE_73= option must be set to ORACLE_73=YES to use the SERIALIZABLE isolation level.

If SPOOL=DBMS, SAS automatically sets READ_ISOLATION_LEVEL=SERIALIZABLE for ORACLE versions 7.3 or later and to READ_ONLY for prior versions. In all other cases, the default value is READCOMMITTED.

When READ_ISOLATION_LEVEL is set to SERIALIZABLE, the CONNECTION option must be set to UNIQUE. If not, an error occurs.

Note: This option should be rarely needed, since the SAS/ACCESS Interface to ORACLE chooses the appropriate isolation level based on other locking options. [cautionend]

Chapter Contents
Previous
Next
Top of Page