ORA-02089: COMMIT is not allowed in a subordinate session
567106Mar 22 2007 — edited Sep 13 2010I am not able to create a table inside a transaction scope.
The following error is displayed "ORA-02089: COMMIT is not allowed in a subordinate session".
I am using OraOLEDB.oracle to connect to a Oracle 10g database. Oracle services for MTS are installed.
I have started a transaction scope like this
TransactionScope tra = new TransactionScope();
and then I spawn a new thread and start a transaction scope with the previous transaction as the ambient transaction , like this
TransactionScope threadtra = new TransactionScope(Transaction.Current);
In this thread I open a connection to Oracle database and make a create command. I get the error I mentioned above.
Is is that the create command in Oracle is Auto-Commit? If it is, how to turn this off?
Any help is welcomed....
Ibra
null