My Oracle Support Banner

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 MARCH 19, 2019

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.