ORA-00932: inconsistent datatypes: expected - got CLOB
The CLOB data type is mapped to LongVarChar in Oracle. Same report runs successfully against some other databases.
CAUSE:This is often caused by the database not support certain functionality on CLOB columns. In this case Oracle does not support doing a select distinct or a group by in a pass of SQL if it contains a CLOB column. This is a database limitation.
ACTION:Upgrade to Strategy 10. Improvements have been made to the SQL engine to prevent columns of these datatypes from being used in passes with group bys/distincts when possible.
