Oracle database error code ORA-00997 – illegal use of LONG datatype

Oracle Database Error Code ORA-997 Description :
illegal use of LONG datatype
Error 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.

How to Solve :
Remove the LONG value from the function or clause.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»