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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms