0 Replies Latest reply: Feb 6, 2013 9:12 AM by 989517 RSS

    Transaction rollback after every OracleTransaction block

    989517
      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.