Skip to Main Content

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 ... 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.
Post Details
Locked due to inactivity on May 24 2013
Added on Nov 3 2008