Re: Closing Cursors

From: Kbat <schmuel_2000_at_yahoo.com>
Date: Fri, 10 Nov 2000 08:28:28 -0700
Message-ID: <8ufqh3$3ah$1@nnrp2.phx.gblx.net>

I believe the cursor is closed when the function/procedure ends. However, not closing cursors explicitly in the procedure is usually bad form.

"Sonia Gillespie" <sonia_gillespie_at_lagan.com> wrote in message news:973762825.18533.0.nnrp-07.9e9859ae_at_news.demon.co.uk...
> When a cursor is returned from a function, is it automatically closed?
> It is returning to a java method, which then closes the result set that it
> retrieves - is it at this point that the cursor is closed?
>
> Thanks in advance,
> Sonia
>
> --
> Sonia Gillespie
> E-mail: sonia_gillespie_at_lagan.com
>
>
Received on Fri Nov 10 2000 - 09:28:28 CST