closing cursor and JDBC

From: Mattias Malmgren <a2matmal_at_ulmo.stud.slu.se>
Date: Mon, 24 Aug 1998 13:51:47 +0200
Message-ID: <35E153D2.3A1BB58B@ulmo.stud.slu.se>

Please take a look at this
http://mattias.kontakt.slu.se/oracle/eng.htm

My Java application is, via JDBC/prepare call repeatingly calling an Oracle
Stored Function that returns a cursor. This example shows that two cursors
are opened, one from the Java application and one in the stored function. The
Java application's cursor can be closed by using cstmt.close(); , but the cursor
opened inside the database will not be closed by using cstmt.close(); . The result
is.

ORA-01000: maximum open cursors exceeded

My question is: How to close the cursor in the database?

/ Mattias Received on Mon Aug 24 1998 - 06:51:47 CDT