Illegal Use of Long DataType Error

[Former Member]

Hi,

I am running a report using Oracle 9.2.0.7 client native connection. When I run it I get a Illegal Use of Long DataType Error ORA-00997. But when scheduled in Business Objects it runs successfully. When I open the report in Crystal Reports XI on the job server it ran on it will give me this error.

There is more than one column in the table with a Long datatype. It shows up in Crystal as a memo field.

Can someone help solve this mystery?

Thanks

[Former Member · Accepted solution]

http://businessintelligence.ittoolbox.com/groups/technical-functional/brio-l/oracle-error-997-ora009...

Check out the above link , you may get some information!!!

~Parsa