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!

ORA-02089: COMMIT is not allowed in a subordinate session

567106Mar 22 2007 — edited Sep 13 2010
I 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

Comments

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

Post Details

Locked on Oct 11 2010
Added on Mar 22 2007
6 comments
38,822 views