Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Missing Null Keyword Oracle 12C

ALTER TABLE READINGS 
     ADD( JSON_COL CLOB 
     CONSTRAINT con_jos_colm CHECK (JSON_COL IS JSON));

I'm trying to run this on Oracle 12.1.0.1.0 (which is suppose to support JSON) but getting this error

Error report -
SQL Error: ORA-00908: missing NULL keyword
00908. 00000 -  "missing NULL keyword"
*Cause:    
*Action:
like image 342
AbdelRahman Badr Avatar asked Oct 28 '25 16:10

AbdelRahman Badr


1 Answers

I'm trying to run this on Oracle 12.1.0.1.0

JSON support was introduced with 12.1.0.2, so your version doesn't support that.

Oracle Database 12c Release 1 (12.1.0.2) New Features