Problem with LONG datatype in Answers
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