SQL & PL/SQL

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-02074

208973Nov 1 2003 — edited Nov 3 2003

Hi
I have a c# application in which i call a procedure. In the procedure i coomit/rollback after doing some DML operations. It works properly in my test database but if i connect the same to the production database it gives an error "ORA-02074 - Cannot commit or rollback in a distributed transaction".

Why is this happening? Is there any parameter setting related to this?

Expecting your reply ASAP.

Thanks
Sasikala

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2003

Added on Nov 1 2003

3 comments

381 views