Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> OpenCursors - ORA-1000
Hi
I have a java server which requests an Oracle database. Sometimes I have this Error:
java.sql.SQLException: ORA-01000: maximum open cursors exceeded but I close all the statements and resultsets.
Does anyone knows how to retrieve the actual number of Open Cursors. In the documentation the maximum is 50 but I would like to be able to retrieve this number dynamically.
Thanks for your help.
Tom.
Received on Fri Aug 20 1999 - 05:43:10 CDT