ODBC Application Causes Access Violation With Statement Size > 4096
Last updated on JUNE 17, 2011
Applies to:Oracle ODBC Driver - Version: 126.96.36.199.5 to 10.2.0.3.0
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
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