How do I close cursors?

From: Anastasios Kotsikonas <tasos_at_csa.bu.edu>
Date: 23 Jun 1999 00:45:29 GMT
Message-ID: <7kpan9$l6u$1@news1.bu.edu>

Hi all,

another newbie question...

I get this exception from my Java app connecting to 8i via JDBC:

Internal Error:
java.sql.SQLException: ORA-01000: maximum open cursors exceeded

        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:181)
        at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:127)
        at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:350)
        at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:129)
        at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:128)
        at lwdb.LWList.GetByName(LWList.java:1944)
        at lwd.List.getList(List.java:436)
        at lwd.action.addUser.Begin(addUser.java:154)
        at lwd.dispatch.WorkerThread.run(WorkerThread.java:246)
java.lang.Exception: Caught in:
        at lwd.cos.email.error.RuntimeError.run(RuntimeError.java:86)
        at lwd.cos.email.error.RuntimeError.<init>(RuntimeError.java:62)
        at lwd.action.addUser.Begin(addUser.java:223)
        at lwd.dispatch.WorkerThread.run(WorkerThread.java:246)

what's causing this?

thanks

tasos Received on Tue Jun 22 1999 - 19:45:29 CDT