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-02041: client database did not begin a transaction

StephenAug 21 2006 — edited Aug 21 2006

Hello All,

I am making calls from oracle 8i to oracle 9i.

First i am inserting values from 8i into a table in 9i.

secondly i am calling a procedure to send mail which again is in 9i database.

If i run the query ..the mail is sent...

if i run it for the second time i get this error

ORA-00164: autonomous transaction disallowed within distributed transaction
ORA-02041: client database did not begin a transaction

If i run it again...The mail is sent...

For every odd transaction the mail is sent and for every even transaction i get this error...Please advice me if you have any tips how i can resolve this..

Thanks,
AK

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2006

Added on Aug 21 2006

1 comment

668 views