Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what's max SQL string length for statement execution?

413268Jan 23 2004 — edited Jan 23 2004
what's the max SQL string length for a statement execution?

I have an application that dynamically executes SQL based upon user input. However, my customers are experiencing errors executing SQL statements that are over 4K in string length, for a SQL SELECT statement.

Can anyone provide the max length of a SQL string that can be executed against an Oracle server? Specifically, Oracle 9.0.1.

If the max length is different for differing versions of the Oracle JDBC driver or Oracle servers, please indicate the differences.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2004
Added on Jan 23 2004
#java-database-connectivity-jdbc
1 comment
2,594 views