My Oracle Support Banner

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.

Symptoms

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.

For example:

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)

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.