Integrated Replicat PL/SQL Error Handler Stops Working or Does Not Get Invoked, Transactions Will Fail With ORA-1403.
Last updated on APRIL 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle GoldenGate - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
A custom PL/SQL DML or Error handler configured with IE stops working.
It may get invoked at the very first time its called to handle the exception after IR re-start, but after that it does not get invoked anymore and the transaction ends up at the IR error queue and discard file with ORA-1403 error.
Note that manually executing the failed transaction thru the Streams API (dbms_apply_adm.execute_error) will work fine and the handler will be invoked normally to resolve the conflict.
Upgraded replication environment from Oracle Streams to Oracle Goldengate.
Configured CDR for Oracle Goldengate thru DBMS_APPLY_ADM.SET_DML_HANDLER.
Migrated Streams to OGG using Streams2OGG tool.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms