String s= rs0.getString(1);
/*statment is created in the function and ResultSet returned */
Error: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
The database setting is 200 cursors
and rs0 has 300 records, rs has only one record each time. I thought there should be only 2 cursors involved, do not know how can get so many.
Could some one help with my question?
Thanks in advance,