MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for Oracle

Transactions

The OLE DB Provider for Oracle implements local transaction support. The consumer can use distributed or coordinated transactions by using Microsoft Distributed Transaction Coordinator (MS DTC). For consumers requiring transaction control that spans multiple sessions, this provider can join transactions initiated and maintained by the MS DTC.

By default, the Oracle Provider uses an autocommit transaction mode, where each discreet action on a consumer session comprises a complete transaction against an Oracle server. For this provider, autocommit mode is local. Autocommit transactions never span more than a single session.

This provider exposes the ITransactionLocal interface, allowing the consumer to use explicitly and implicitly started transactions on a single Oracle connection. This provider does not support nested local transactions.

The Transaction Unit Of Work (UOW) as reported by GetTransactionInfo will always be NULL. For example, if a transaction is obtained from a session, and GetTransaction is called on it, the XACTUOW from the XACTTRANSINFO will always be NULL.

When using this provider with Component Services (or MTS, if you are using Windows NT) to enlist global transactions, the file Mtxoci.dll is required.