oracle blob 非空,ORA-00908：Oracle SQL中缺少NULL关键字（blob数据类型）

您似乎在其版本不支持您正在执行的操作的数据库中。例如11gR2：

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

SQL> CREATE TABLE test

2 (

3 log_id NUMBER (19, 0) CONSTRAINT pk_lid PRIMARY KEY,

4 data_before BLOB,

5 data_after BLOB,

6 constraint data_before_json CHECK (data_before IS json),

7 constraint data_after_json check (data_after is json)

8 )

9 lob (data_before) store as(storage (next 15m)),

10 lob (data_after) store as(storage (next 15m));

constraint data_before_json CHECK (data_before IS json),

*

ERROR at line 6:

ORA-00908: missing NULL keyword

在12.2：

BANNER CON_ID

-------------------------------------------------------------------------------- ----------

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0

PL/SQL Release 12.2.0.1.0 - Production 0

CORE 12.2.0.1.0 Production 0

TNS for Linux: Version 12.2.0.1.0 - Production 0

NLSRTL Version 12.2.0.1.0 - Production 0

SQL> CREATE TABLE test

2 (

3 log_id NUMBER (19, 0) CONSTRAINT pk_lid PRIMARY KEY,

4 data_before BLOB,

5 data_after BLOB,

6 constraint data_before_json CHECK (data_before IS json),

7 constraint data_after_json check (data_after is json)

8 )

9 lob (data_before) store as(storage (next 15m)),

10 lob (data_after) store as(storage (next 15m));

Table created.

SQL>

请注意您和我的代码之间的区别。