JSON column OCI Error ORA-02290: Check Constraint Violated (status = 2290) (Doc ID 2282399.1)

Last updated on JULY 06, 2017

Applies to:

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

Symptoms

 

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:

 

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