A Union Report with a Sort on a CLOB Column Fails in Oracle Analytics Server with Error: ORA-00932 Inconsistent Datatypes
(Doc ID 2762219.1)
Last updated on MARCH 22, 2021
Applies to:Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.
In OBIEE 12c, CLOB columns in an Oracle Database table are modeled in the RPD by specifying a Descriptor ID column and the LOOKUP function; in this way, the CLOB column will not be included in the GROUP BY or ORDER BY clause of the Physical SQL that gets sent to the Oracle Database.
RPD Presentation Column: Remark Long Description
RPD Logical Column: Remark Long Description
Sort Order Column: Remark
Description ID Column: Remark
LTS Expression: LOOKUP (DENSE <Physical Column REMARKLD>, <Physical Column ROW_WID>)
RPD Column: REMARKLD is of type LONGVARCHAR(32768)
Oracle Database: REMARKLD column is of type CLOB, REMARK column is of type VARCHAR
After migration to OAS, Union reports with the CLOB column now fail with the following error:
[nQSError:17001]Oracle Error code:932, message: ORA-00932: inconsistent datatypes: expected - got CLOB at OCI call OCIStmtExecute. (HY000)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document