Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Closing cursors returned from stored procs to C++

Closing cursors returned from stored procs to C++

From: Hugh Pendry <hpendry_at_trinitech.co.uk>
Date: Thu, 12 Aug 1999 14:02:08 +0100
Message-ID: <7ougkh$smj$1@trinitech.demon.co.uk>


I have a stored proc which has a ref cursor as an in out parameter

When I call this proc from C++ (via ODBC API) will the cursor be automatically closed once I have finished fetching the data from it? Or will every call open a new cursor which never gets closed? Or do further calls to the stored proc reuse the same cursor?

How do I found out how many cursors are open in Oracle?

thanks
hugh Received on Thu Aug 12 1999 - 08:02:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US