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 later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

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.

	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

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