D.24 HS_FDS_TRANSACTION_ISOLATION
HS_FDS_TRANSACTION_ISOLATION
initialization parameter for Oracle Database Gateway for SQL Server.
Property | Description |
---|---|
Default Value |
|
Range of Values |
{ |
Syntax |
|
HS_FDS_TRANSACTION_ISOLATION
specifies the isolation level that is used for the transaction that the gateway opens on the non-Oracle database.
The isolation levels of READ_UNCOMMITTED
, READ_COMMITTED
, REPEATABLE_READ
, and SERIALIZABLE
are the four isolation levels defined in the SQL standard and adopted by both ANSI and ISO/IEC. For additional information regarding them, see Oracle Database
Concepts.
Use caution when specifying an isolation level lower than the Oracle transaction isolation level being used, as the gateway transaction will have different Preventable Read Phenomena from what will occur in the Oracle database transaction.
Parent topic: Initialization Parameters