Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Transaction rollback after every OracleTransaction block

989517Feb 6 2013
Good morning,
We are using traditional ado.net SQL via 32 bit odp.net in a .NET 4 solution. We are noticing what appears to be a rollback statement issued after block of SQL statements within an OracleTransaction. Switching over to TransactionScope from OracleTransaction appears to fix the problem as well as going back to the .NET 2 Microsoft Oracle driver. At this point going back to the Microsoft driver is not an option as it is no longer supported by Microsoft going forward. Is anyone aware of a way to configure odp.net to not issue a rollback statement after every SQL statement(s) without having to switch everything over to using TransactionScope? Thank you.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 6 2013
Added on Feb 6 2013
0 comments
110 views