Hello,
I have this error 'ORA-02074: cannot Rollback in a distributed transaction' in a stored procedure of PL/SQL. In a FOR LOOP, when I have an error, I make a Rollback in the EXCEPTION and I get this error. I had looed up in the Server Messages but was not helpful. I would like to add that I
I
don't know if this is related to what we are going through here, apparently
Oracle treats transactions via db link as 2-phase commit transactions unless SET
TRANSACTION READ ONLY is used.
Check
dba_2pc_pending to see if you have hung 2-phase commit
transactions.
If you
do, do a search
24, 2002 8:48
AM
Subject: ORA-02074: cannot Rollback in a
distributed transaction
Hello, I have this error 'ORA-02074: cannot Rollback
in a distributed transaction' in a stored procedure of PL/SQL. In a
FOR LOOP, when I have an error, I make a Rollback in the EXCEPTION and I get