Can anyone describe "Crystal Repo开发者_开发技巧rt Engine Returns Error Code 997" for Crystal Reports 6.0? Googling proved futile.
Are you using a long
datatype in the data source?
If your theory is right, and if you have the long
datatype in either a CONNECT BY
, GROUP BY
, or ORDER BY
clause, that could be the culprit. From what I have read, the ORA-00997 error is as follows:
ORA-00997: illegal use of LONG datatype:
Cause: A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause.
I have seen Crystal Reports bubble up unhandled SQL Server errors before, so it's possible.
精彩评论