oracle 00932 get clob,oracle – ORA-00932：不一致数据类型：expected – 获取CLOB

考虑到TEST_SCRIPT是一个CLOB为什么当我在Oracle上从sql * PLUS运行这个简单的查询时，我得到错误：

ORA-00932: inconsistent datatypes: expected - got CLOB

我已经阅读了很多关于同样的错误的问题，但没有一个运行从sqlPLUS直接查询

UPDATE IMS_TEST

SET TEST_Category = 'just testing'

WHERE TEST_SCRIPT = 'something'

AND ID = '10000239'

完整示例：

sql> create table ims_test(

2 test_category varchar2(30),3 test_script clob,4 id varchar2(30)

5 );

Table created.

sql> insert into ims_test values ('test1','something','10000239');

1 row created.

sql> UPDATE IMS_TEST

2 SET TEST_Category = 'just testing'

3 WHERE TEST_SCRIPT = 'something'

4 AND ID = '10000239';

WHERE TEST_SCRIPT = 'something'

*

ERROR at line 3:

ORA-00932: inconsistent datatypes: expected - got CLOB