I'm wondering what the best practices are for using a CallableStatement and the prepareCall function in a loop that is very large. The way it was currently coded it ends with the amount of cursors being exceeded. Thus I moved the creation of the CallableStatement outside of the loop and this seems to work but I'm wondering that the best practices are ? Here is an example of the code , please let me know what I'm doing wrong ? Should I be closing "myCallable" after each executeUpdate and if so will that affect the rollback or commit ?
Will "executeBatch" work even if there are 120,000 rows ?
Bhagat Singh Rawat
Joined: Apr 04, 2009
Jason Bauer wrote:Will "executeBatch" work even if there are 120,000 rows ?
I believe it should work Please check with "how executeBatch method works in JDBC"
Joined: May 28, 2009
I tried it but I can't use it because we are using OUT variables in our Oracle function. Oh well , my code works as is today with the CallableStatement outside the loop. Unless anyone can tell me a reason to not do it the way it's currently coded I'll proceed.