一则> ORA-00932: inconsistent datatypes: expected - got CLOB 错误处理的方法

原报错SQL

Where 1=1  and a.istat = 0  and ListUser='admin'  order by iStat desc, sDate Desc

错误信息如下：

ORA-00932: inconsistent datatypes: expected - got CLOB 

经查表结构发现该字段为clob类型

SELECT table_name, column_name, data_type,DATA_LENGTH,COLUMN_ID FROM all_tab_cols WHERE table_name =upper('b_FlowLeave')

解决方法：

在查出来字符串长度小于4000的时候可以用dbms_lob.substr(clob_column)这个oracle内置的函数进行clob转字符串操作

Where 1=1  and a.istat = 0 and dbms_lob.substr(ListUser)='admin' order by iStat desc, sDate Desc