Maximum open cursors exceed
Posted on 2006-06-15
I have a problem with Open Cursor in ORACLE JDBC. While im handling 3 different results sets im getting the following error.
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
I have tried other solutions by increasing pool size and cursor size. I have to handle 10000 records which are coming form each ResultSet.
Its very urgent. Reply ASAP...