4 DBMS_APPLY_ADM.EXECUTE_ERROR(LOCAL_TRANSACTION_ID => C.LOCAL_TRANSACTION_ID,EXECUTE_AS_USER => FALSE);
5 DBMS_OUTPUT.PUT_LINE(C.LOCAL_TRANSACTION_ID || ' IS CORRECTED!');
6 EXCEPTION
7 WHEN OTHERS THEN
8 DBMS_OUTPUT.PUT_LINE(C.LOCAL_TRANSACTION_ID || 'IS STILL ERROR');
9 END;
10 END LOOP;
11 END;
12 /
15.44.73939 IS CORRECTED!
17.36.73153 IS CORRECTED
17.56.73169 IS CORRECTED
14.79.72956 IS CORRECTED!
PL/SQL procedure successfully completed.
SQL> COMMIT;
Commit complete.
SQL> SELECT * FROM DBA_APPLY_ERROR;
no rows selected
重新应用错误后,问题解决。