ODAC

TOraIsolationLevel Enumeration

Specifies the way the transactions containing database modifications are handled.

Unit

Ora

Syntax

TOraIsolationLevel = (ilReadCommitted, ilSerializable, ilReadOnly);

Values

Value Meaning
ilReadCommitted If the transaction contains DML that requires row locks held by another transaction, then the DML statement waits until the row locks are released. The default Oracle behavior.
ilReadOnly All subsequent queries in that transaction only see changes committed before the transaction began. Read-only transactions are useful for reports that run multiple queries against one or more tables while other users update these same tables.
ilSerializable Specifies serializable transaction isolation mode as defined in the SQL92 standard. If a serializable transaction contains data manipulation language (DML) that attempts to update any resource that may have been updated in a transaction uncommitted at the start of the serializable transaction, then the DML statement fails.

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback