ora-10000 maximum open cursors exceeded exception.
posted 4 years ago
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);
if(recourdCount == 1000)
// batch insert logic.
} Can you tell me what might be the issue?