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 laterInformation in this document applies to any platform.
Symptoms
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.
Changes
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 |
Changes |
Cause |
Solution |