Last updated on JULY 06, 2017
Applies to:Oracle GoldenGate - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Consider following table that has a JSON column (in an Oracle database):
CREATE TABLE "MSP"."J_ORDERS"
( "ID" VARCHAR2(250 CHAR) NOT NULL ENABLE,
"ACCOUNTID" VARCHAR2(250 CHAR),
"COMCASTACCOUNTGUID" VARCHAR2(250 CHAR),
"ORDER" CLOB, <======= JSON contents stored in this CLOB column
CONSTRAINT "ENSURE_JSON" CHECK ("ORDER" IS JSON) ENABLE, <=== Constraint to check for JSON content
While replicating this table with Oracle GoldenGate, and INSERT operation gets the replicat to abend with below error:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms