My Oracle Support Banner

ORAOLEDB: Long SQL(Over 64KB) Cause ORA-00907 (Doc ID 3001421.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Oracle Provider for OLE DB - Version 12.2.0.1 and later
Microsoft 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.