JDBC Bound variable limit for sql queries
725288Sep 30 2009 — edited Oct 2 2009I have a backend 10.2.0.4 DB server and am connecting via oracle 10.2.0.4 JDBC driver
I need to know if there is a limit on the no of variables that can be bound using a prepared Statement ?
A query like this :
select * from table where column in(?, ?, ?.....)
cannot have more than 1000 variables ?
If yes .. is there a way around it ?
Any help would be greatly appreciated