ora-10000 maximum open cursors exceeded exception.
Shankara Sharma
Ranch Hand
Posts: 48
posted 4 years ago
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?
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?
