My Oracle Support Banner

OAC : [NQSError: 17001] ORA-00932 Error When Using CLOB Column with Union Operator (Doc ID 2519224.1)

Last updated on NOVEMBER 28, 2019

Applies to:

Oracle Analytics Cloud - Version 18.3.3 and later
Information in this document applies to any platform.


On Oracle Analytics Cloud , BI

When using a CLOB column in an analysis (OAC) with UNION clause, it fails with below error : 

[nQSError: 17001] Oracle Error code: 932, message: ORA-00932: inconsistent datatypes: expected - got CLOB at OCI call OCIStmtExecute. (HY000)

This CLOB column is a formula column in RPD using Lookup() as follows :

LookUp([DENSE] value_column, expression_list )


Note: The same scenario worked in BICS but not in OAC.




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

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