OracleTransaction has no effect

R

R. Sterrenburg

Hi,

I use the OracleTransaction class. I use multiple OracleCommands
participating in the same OracleTransaction.
When one of the OracleCommands fail when executing and I do a rollback on
the OracleTransaction it does NOT rollback the previous commands. It seems
like the connection? is auto commiting each command I execute.

Does anyone know how to solve this?

Regards,
René
 
R

R. Sterrenburg

Sorry, I made a very stupid mistake by including an explicit COMMIT in the
stored procedure of one of the commands!

René
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OracleConnection.BeginTransaction() calls OracleCommand.ExecuteNonQuery() internally? 3
RollbackTransaction is not working with Oracle .Net Data Provider 1
Updating database rows usign OracleClient - .NET Framework 1.1 4
This OracleTransaction has completed; it is no longer usable 1
OracleConnection 7
Object must implement IConvertible, writing to BLOB 6
debug suggestion for connection pool problem with Oracle using daa 6
Factory class with ADO.NET commands containing parameters 1

Top