ORA-01000: maximum open cursors exceeded

Edi Weitz <[email protected]> Thu, 08 Sep 2005 14:41:25 +0200
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
Hi!

There's a bug with CLSQL (3.2.1) and Oracle (I'm using 10gR2 on Linux)
that can be reproduced (tested with several Lisps on Windows and
Linux) as follows:

1. Load CLSQL-ORACLE.

2. Connect to an Oracle database.

3. Execute the following form for a sequence that doesn't exist:

     (dotimes (i 1000) (ignore-errors (drop-index "foo")))

4. Now do this:

     (list-indexes)

This results in 

  Error: A database error occurred on database #<CLSQL-ORACLE:ORACLE-DATABASE orcl/edi OPEN 226793EC>: 1000 / NIL
    ORA-01000: maximum open cursors exceeded

so it looks as if CLSQL doesn't release all OCI resources in case of
a database error.

I can try to investigate this but maybe someone else knows the code
good enough to find the problem immediately.

Thanks,
Edi.