Dbms_transaction.PURGE_LOST_DB_ENTRY - ORA-01453: SET TRANSACTION must be first statement of transac
Hi, I have zombie 2pc transactions, I tryed to clean the istance using:
BEGIN
FOR REC_CUR IN (SELECT * FROM SYS.dba_2pc_pending) LOOP
Dbms_transaction.PURGE_LOST_DB_ENTRY (REC_CUR.LOCAL_TRAN_ID);
END LOOP;
END;
/
But I got this error:
ERROR at line 1:
ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-06512: at "SYS.DBMS_TRANSACTION", line 74
ORA-06512: at "SYS.DBMS_TRANSACTION", line 96
ORA-06512: at line 4
On MOS i've found Manually Resolving In-Doubt Transactions: Different Scenarios (Doc ID 126069.1)
Where is wrote this:
** NOTE1: If using Oracle 9i or later and DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY fails with