Ogg v12.2 replicat throws SQL error 31011 when dealing with Trigger (Doc ID 2281029.1)

Last updated on JUNE 27, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

When using NOSUPPRESSTRIGGERS and dealing with a table which have CLOB, the ogg v12.2.x replicat fails with error similar to

OCI Error ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00229: input source is empty
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at "RAPPORT_DELLPRINT.TR_GG_ENTITY_DATA_U", line 15
ORA-04088: error during execution of trigger

If using a ogg v11.2.x replicat against the same table, it runs all good and the trigger gets executed correctly



Cause

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