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.