Re: How do I close cursors?

Hi,

You need to increase the Oracle initialization parameter : OPEN_CURSORS. It's a maximum number of cursors that can be opened by a session.

Anastasios Kotsikonas a écrit dans le message <7kpan9$l6u$1_at_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:12 8)
> 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 Wed Jun 23 1999 - 02:18:45 CDT