Re: Closing Cursors

Cursors can only be closed by the program opening them. As the dbms_sql.open_cursor call returns a handle, you should have no problem at all -in your programs- to close that cursor. You should be aware that unlike ordinary cursors, dbms_sql cursors are *not* closed if the program raises an exception. You should always have an exception section in your pl/sql program to close any cursors, you didn't close explicitly before.

Hth,

Sybrand Bakker, Oracle DBA

"Sonia Gillespie" <sonia_gillespie_at_lagan.com> wrote in message news:964088025.22001.0.nnrp-08.9e9859ae_at_news.demon.co.uk...
> Does anyone know of a way of closing cursors that are lying open on the
> database? I'm using Oracle 7.3.4 on Windows NT 4.
>
> I've seen the open cursors in the V$opoen_cursors table and know of the
> dbms_sql.close_cursor, but am not too sure what I should pass as the
> parameter if this works at all!
>
> Can anyone help?
>
> Thanks,
>
> Sonia.
>
> --
> Sonia Gillespie
> E-mail: sonia_gillespie_at_lagan.com
>
>
Received on Thu Jul 20 2000 - 00:00:00 CDT