• 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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic