We are using Oracle 8.1.7 and in JDBC driver ‘Enable Resultset’ is ON
and ‘Enable Closing cursors’ is OFF
maybe you should first try ‘Enable Closing cursors’ ON
Are you using bind variables?
that would help a lot
Also is the latest 8.1.7 patch installed, I remember having this problem a long time ago and it was fixed by both a patch and a little change of code using bind variables and avoiding opening cursor in the loop of another cursor …. garbage collection can take some time to destroy the cursors or recordsets in the inner loop
hope that helps a bit
have a good day and a happy new year