Kbase P126583: Unable to process results: com.easyask.EAException: ORA-00932: inconsistent datatypes: expected -
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/3/2008 |
|
Status: Unverified
SYMPTOM(s):
Unable to process results: com.easyask.EAException: ORA-00932: inconsistent datatypes: expected - got CLOB
Querying Oracle CLOB column or field fails
FACT(s) (Environment):
EasyAsk 9.6
Oracle
CAUSE:
Oracle does not allow equality-type searches against CLOBs because they may contain very large values
FIX:
Change the query to do a contains-type search (List ... where CLOB Column contains 'text'), and set the "Soft Search" property on the Column properties dialog.