Kbase 20943: Oracle dataserver - Inconsistent datatype error against Oracle LONG column
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
ORACLE error -932 see "ORACLE Error Messages and Code Manuals". (1252)
**inconsistent datatypes
Error occurs when a query with a LONG Oracle column in WHERE clause
CAUSE:
This is Oracle Limitation.
LONG columns can store text, arrays of characters, or even short documents. You can reference LONG columns in UPDATE, INSERT, and (most) SELECT statements, but NOT in expressions, SQL function calls, or certain SQL clauses such as WHERE, GROUP BY, and CONNECT BY.
Since LONG columns are binary in nature, performing a WHERE clause against it (LONG column) cannot be done.
FIX:
Since this is an Oracle limitation, Progress cannot perform the same type of query either.