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

515114Nov 22 2006 — edited Nov 22 2006

Hi!

I have a serious problem in my j2ee application. The description of the situation :

1)There is a PL/SQL procedure in the local database which calls a remote procedure (which is in a different database). The remote procedure then updates certain tables in that remote database.
2)In most cases it all works just fine. But after some time i keep getting ORA-02046 errors in the logfile.

Is it somehow related to the fact that Oracle uses two phase committing?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 20 2006

Added on Nov 22 2006

#general-database-discussions

1 comment

1,050 views