Problem with LONG datatype in Answers

Kishore GuggillaNov 3 2008 — edited Apr 26 2013

Hi Experts,

I have a column of LONGVARCHAR datatype in my physical layer or in database.
When i use this column in request, Its throwing an error saying that Illegal use of LONG datatype.
here is the error code:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 997, message: ORA-00997: illegal use of LONG datatype at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)

I gone through this http://ora-00997.ora-code.com/ ... but i am not using this column in any of those mentioned.
I also done casting and changing datatype in physical layer itself for that particular column...

But no use... i need this as early as possible.. please help me in avoiding this error.

Thank you very much..

Thanks & Regards
Kishore Guggilla

Locked Post

New comments cannot be posted to this locked post.

Locked due to inactivity on May 24 2013

Added on Nov 3 2008

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #error, #obiee, #report

9 comments

7,940 views