This discussion is archived
8 Replies Latest reply: Oct 7, 2013 4:34 AM by SrikanthGH RSS

Reporting on CLOB not working in OBIEE

Apoorv Newbie
Currently Being Moderated
Hi,

I have followed the steps mentioned in the link http://www.rittmanmead.com/2010/08/oracle-bi-ee-11g-reporting-on-clobs-lookups/.

Still I get the following error:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [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)

I do not want to cast the column formula and then use in the report. I want to directly use the column from Presentation layer and directly report on it.
Any Ideas?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points