JSON column OCI Error ORA-02290: Check Constraint Violated (status = 2290)
Last updated on JULY 06, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms