Re: ORA-01000-Maximum open cursors exceeded

Hello Preetha,

I am having the same problem with Oracle and Java. I have increased the open_cursors in the init.ora file and in my code I explicitly close all record set objects after use and then set them to null.

I have been monitoring the v$open_cursor table and it just seems to increase with never releasing the cursors. If you get an answer let me know as I can't figure this out either.

Kev.-

On Tue, 3 Apr 2001 09:49:01 +0530, "Preetha Suri" <Preetha.Suri_at_sisl.co.in> wrote:

>Hello,
>
>I am using the Java JDBC-ODBC Bridge to access an Oracle database.
>
>SQL SELECT statements are executed in a loop.
>
>At the end of each iteration, I am explicitly calling ResultSet.close() to
>close the ResultSet object and I set the ResultSet object to null after
>closing it.
>
>Still, I get the error :
>ORA-01000:maximum open cursors exceeded.
>
>I would like to solve this problem without resetting the number of
>OPEN_CURSORS in ORACLE.
>
>Do you have any tips to solve this problem ?
>
>Thanks in advance.
>
>Regards,
>Preetha.
>
>
>
Received on Tue Apr 03 2001 - 21:01:05 CDT