Oracle Database Discussions

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-02046: distributed transaction already begun

Fahd.MirzaApr 15 2010 — edited Apr 15 2010

Hi,
I have written a PL/SQL procedure, which is inserting some records in a remote table in another database through dblink. First time, the procedure runs fine, but when I try to run it second time, it gives me following error:

ORA-02046: distributed transaction already begun

Is there any solution or workround to this problem?

Thanks and regards

This post has been answered by Rajesh Lathwal on Apr 15 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2010

Added on Apr 15 2010

#general-database-discussions

9 comments

16,188 views