Forum Stats

  • 3,817,445 Users
  • 2,259,334 Discussions


Transaction rollback after every OracleTransaction block

989517 Member Posts: 1
Good morning,
We are using traditional SQL via 32 bit 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 to not issue a rollback statement after every SQL statement(s) without having to switch everything over to using TransactionScope? Thank you.
This discussion has been closed.