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

Symptoms

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