最佳答案
考虑到 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