My Oracle Support Banner

ODBC Application Causes Access Violation With Statement Size > 4096 (Doc ID 398917.1)

Last updated on JUNE 17, 2011

Applies to:

Oracle ODBC Driver - Version: 9.2.0.6.5 to 10.2.0.3.0
Microsoft Windows (32-bit)

Symptoms

An ODBC Application with a SQL Statement > 4093 characters in length terminates with access violation. In the case of ASP/VB silently.

A Stack Trace shows SQLExecDirectW()  is the faulting command.

An ODBC trace will show the following error

 

Failure Calling SQLExecDirect 
State: S1000 
Native Error: 1704 
Error Message: [Oracle][ODBC][Ora]ORA-1704: string string literal too long 


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.