Displaying clob datatype in OBIEE
GJApr 20 2011 — edited Apr 20 2011I have column with clob datatype. When I try to display the value in obiee answers it throws the below error. Please help me how to display this clob column in OBIEE answers thanks.
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 932, message: ORA-00932: inconsistent datatypes: expected - got CLOB at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)