Problem with [Oracle Sample Code Repository Entry# 581]

From: Hugh Pendry <hpendry_at_trinitech.nospam.co.uk>
Date: Thu, 24 Feb 2000 11:22:30 -0000
Message-ID: <89349n$h3v$1@trinitech.demon.co.uk>

The sample code has this header:-

---

---

Name: ODBC ResultSets from a stored procedure Category: ODBC
Port: WIN32
Description: This returns 2 refcursors from a stored procedure and fetches upon them with the C ODBC API.

---

---

The problem is if you put the code to execute the stored procedure and fetch the result sets within a loop and continually run it then the cursors remain open until you hit the max open cursors error. From what I can tell the only bit of code that will close the cursors is to disconnect (i.e. end the session).

Am I missing a less drastic way of closing cursors?

Or is this a bug?

Or is it part of the ODBC Driver design not to be able to close cursors from within a session?

I am using Oracle8 ODBC Driver 8.0.5.1b.0

Using Java and JDBCthere seems to be no problem with cursors

Thanks for any pointers at all. Received on Thu Feb 24 2000 - 05:22:30 CST