ExecuteNonQuery Commits Work Immediately Despite .NET Transaction Is In Aborted State
(Doc ID 1634046.1)
Last updated on MARCH 24, 2022
Applies to:
Oracle Data Provider for .NET - Version 11.2.0.3 and laterGeneric Windows
Symptoms
Executing a call to ExecuteNonQuery to submit DML inside a .NET TransactionScope (distributed transaction) that is in an aborted state results in ODP.NET committing data when an exception should be raised.
For Example, the following simple test case demonstrates the issue:
1. DDL to create the table and populate.
3. Observations.
The data is committed but should not be.
SQL> select * from test;
ID VALUE
---------- ----------
1 100
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |