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: to
Microsoft Windows (32-bit)


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 


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