Re: ORA-01000 exceeded max. number of open cursors

am_heiner_at_bigmailbox.net (Heiner) wrote in message news:<e592de1.0108122308.112e5208_at_posting.google.com>...
> Hi there,
>
> I'm using 8.1.7 from within java (JDBC archive date is June 30th,
> 2000). Pseudocode looks like this:
>
> void whatever() {
> while(!many_calls) {
> myVar = makeCall();
> }
> }
>
> myType makeCall() {
> try {
> ...
> rset = ...
> ...
> } finally {

 if (null != rset) rset.close();
> }
> }
>
> As one can see, I do many JDBC calls and for any call it is
> guaranteed, that the cursor ist closed, since the close statement is
> inside the finally-block. However, I always get the ORA-01000 error
> while doing the many-calls. Is there a known bug, when doing many JDBC
> calls? Any help will be greatly appreciated.
>
> regards
> Heiner

Hi,

    Increase the number of open_cursor in initSID.ora. The default is 300 I believe.

Allan W. Tham
DBA Received on Mon Sep 03 2001 - 07:27:14 CEST