Handle Transactions with the Oracle Database adapter
Microsoft BizTalk Adapter for Oracle Database does not initiate a transaction while performing an operation on the Oracle database. Instead, the adapter performs the operations using the transaction context provided by the adapter clients. In order to perform operations in a transaction using the Oracle Database adapter, you must:
Enable transactions in the adapter clients. For example, to enable transactions in BizTalk Server, you must select the Use Transaction check box in the Transactions area of the Messages tab for a WCF-Custom or WCF-OracleDB port.
Set the value of the UseAmbientTransaction binding property to True in the adapter. For more information about the binding property, see Configure the binding properties for Oracle Database.
To use the adapter to perform transactions on the Oracle database, you must have installed the Oracle Services For Microsoft Transaction Server component, while installing the Oracle client, on the computer running the adapter client.
Transactions in the Outbound Operations
The Oracle Database adapter performs an outbound operation in a single transaction. For composite operations, all the operations are performed in a single transaction but using different ODP.NET connections. For more information about the outbound operations surfaced by the Oracle Database adapter, see How does the Adapter Surface Oracle Metadata?.
Transactions in the Inbound Operations
The Oracle Database adapter exposes the following two inbound operations:
Polling: The polling statement and the post-poll statement (if specified) are executed in a transaction, whereas, the polled data available statement is executed in a different transaction. Similarly, the polling statement and the post-poll statement are executed using the same ODP.NET connection, whereas, the polled data available statement is executed using a different ODP.NET connection.
Notification: The notification operation is performed in a transaction using a single ODP.NET connection.
For more information about the inbound operations surfaced by the Oracle Database adapter, see How does the Adapter Surface Oracle Metadata?.