Re: Closing Cursors

I was able to test the close of cursors with the help of a local Oracle DBA who was able to watch my ADO function from the server side.

The cursors created by the ADO object were closed when the Visual Basic function terminated. However, two additional cursors created internally by Oracle remained open until the entire VB app was terminated.

Praetorian

In article <8hj4g0$3cs$1_at_nnrp1.deja.com>,   Praetorian <morbius6_at_my-deja.com> wrote:
> Is it necessary to close a cursor in the code of a procedure, or does
> the cursor close when the procedure completes?
>
> I am calling a stored procedure from Visual Basic with ADO 2.5. I need
> the cursor open in order to retrieve the results set, but I don't want
> to leave the cursor open indefinitely on the server side.
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Wise men still seek Him.


Sent via Deja.com http://www.deja.com/
Before you buy.