ORAOLEDB: Long SQL(Over 64KB) Cause ORA-00907
(Doc ID 3001421.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Provider for OLE DB - Version 12.2.0.1 and laterMicrosoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
Symptoms
Long SQL(Over 64KB) cause ORA-00907 on OraOLEDB.
Confirming SQL trace, The SQL seems to be clipped in the middle.
Ex:
Right:
SELECT ...
,DECODE(DAYS,4,KKO_NM,NULL) AS DAY5,
,DECODE(DAYS,5,KKO_NM,NULL) AS DAY6 ..
This issue:
SELECT ...
,DECODE(DAYS,4,KKO
,DECODE(DAYS,5,KKO_NM,NULL) AS DAY6 ..
"_NM,NULL) AS DAY5," is cut off.
So, if you've got a strange ORA- error in long SQL on OraOLEDB, you might have this problem.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |