ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BLOB
SQL> SELECT  b.INFO_SORT_NAME, a.INFO_ID, a.INFO_TITLE, a.OPERUSER,
  2  a.OPER_TIME ,a.COLOR FROM MT_INFO a, MT_INFO_SORT b WHERE 1 =1
  3  AND a.INFO_SORT_CODE = b.INFO_SORT_CODE
  4  AND  b.INFO_SORT_CODE = 'INFO0016'
  5  AND ( a.INFO_TITLE LIKE '%期货%' OR a.INFO_CONTENT like '%期货%')
  6  ORDER BY a.OPER_TIME DESC,b.INFO_SORT_CODE, a.INFO_ID DESC;
AND ( a.INFO_TITLE LIKE '%期货%' OR a.INFO_CONTENT like '%期货%')
                                    *
第 5 行出现错误:
ORA-00932: 数据类型不一致: 应为 NUMBER, 但却获得 BLOB


SQL> desc MT_INFO_SORT;
名称                                      是否为空? 类型
----------------------------------------- -------- ---------------------------

INFO_SORT_ID                              NOT NULL NUMBER(10)
INFO_SORT_CODE                                     VARCHAR2(60 CHAR)
INFO_SORT_NAME                                     VARCHAR2(120 CHAR)
LOCATE_NO                                          FLOAT(126)
INFO_SORT_TYPE                                     NUMBER(5)
VALID_FLAG                                         NUMBER(5)
MESSAGE_FLAG                                       NUMBER(5)
EXISTING_FLAG                                      NUMBER(5)
INDEX_FLAG                                         NUMBER(5)
NOUS_FLAG                                          NUMBER(5)

SQL> desc mt_info;
名称                               &