• Post Reply Bookmark Topic Watch Topic
  • New Topic

ora-10000 maximum open cursors exceeded exception.

 
Shankara Sharma
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am trying to insert 20000 records into database using batch insertion in JDBC by iterating through result set object.

But i am getting an ora-10000 maximum open cursors exceeded during batch insertion. I instantiated PreparedStatement object before iterating through result set.
PreparedStatement statement = connection.createStatement(query);
while(resultset.next())
{
if(recourdCount == 1000)
{
// batch insert logic.
}
}

Can you tell me what might be the issue?
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!