Closing Cursors and ODBC (How To?)

Hi

does anyone know how to close refcursors returned from an Oracle stored proc, they are returned via the ODBC API to a C++ program.

Each time I call the stored proc each returned ref cursor creates one more entry in the view v$open_cursor. There a 5 refcursors so the first time I call the proc I have 5 open cursors, the second time there are 10 open cursors until eventually the number of cursors exceeds whatever the limit is for max open cursors.

Whatever I do on the C++ side doesn't seem to close the cursors I've tried SQLCloseCursor, SQLFreeStmt and SQLEndTrans. They only seem to close when I end the session.

Any ideas?

Hugh

(If replying direct please remove nospam from the address) Received on Wed Feb 23 2000 - 05:42:06 CST