title: Oracle 12C: Error getting while create BLOB column table with JSON type
body: <p>While trying to create a table with column as BLOB data type holding JSON value, I am putting one constraint to check whether the BLOB column is JSON or not. I am getting below error in Oracle 12C database.</p>
  
  <pre><code>CREATE TABLE colorTab  (
  id NUMBER, 
  color BLOB ) ;
  
  ALTER TABLE colorTab 
  ADD CONSTRAINT ensure_json CHECK (color IS JSON STRICT);
  </code></pre>
  
  <p>Error:</p>
  
  <p>Table COLORTAB created.</p>
  
  <blockquote>
    <p>Error starting at line : 7 in command -
    ALTER TABLE colorTab 
    ADD CONSTRAINT ensure_json CHECK (color IS JSON STRICT)
    Error report -
    ORA-40499: no format defined for binary data type
    40499. 00000 -  "no format defined for binary data type"
    *Cause:    The provided JSON input was of binary type but a format was
               not defined.
    *Action:   Define a format for binary input.</p>
  </blockquote>
  
  <p>I am referring to the below blog in oracle:</p>
  
  <p><a href="https://blogs.oracle.com/jsondb/entry/storing_json_in_blob_columns" rel="nofollow noreferrer">https://blogs.oracle.com/jsondb/entry/storing_json_in_blob_columns</a></p>