Integrated Replicat PL/SQL Error Handler Stops Working or Does Not Get Invoked, Transactions Will Fail With ORA-1403.

(Doc ID 2111039.1)

Last updated on APRIL 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle GoldenGate - Version 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