UPDATE_ISOLATION_LEVEL=

UPDATE_ISOLATION_LEVEL=

Specifies which isolation level to use when reading ORACLE tables for update.

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

Syntax
Details

Syntax

UPDATE_ISOLATION_LEVEL= READCOMMITTED | SERIALIZABLE

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

Details

The ORACLE_73= option must be set to ORACLE_73=YES to use the SERIALIZABLE method.

If UPDATE_LOCK_TYPE=NOLOCK, SAS automatically sets UPDATE_ISOLATION_LEVEL= SERIALIZABLE for ORACLE versions 7.3 or later and READ_ONLY for prior versions. In all other cases, the default value is READCOMMITTED.

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