My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


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