Re: REF CURSOR

Comments embedded.
On Feb 6, 1:34 am, Guru <guruprasa..._at_gmail.com> wrote:
> Dear All,
>
> I want to close all Opened Ref Cursor in my application.

The write some decent code and clean up your mess before you leave the playground, not after.

>
> For this, How shall i get Opened Ref Cursor Name's using V
> $OPEN_CURSOR? Or Any other way to find opened Ref Cursor names in
> ORACLE 9i?
>

If this truly is your application, then you need some serious education on how to write one, as leaving open cursors lying about is truly abysmal technique.

> Thanks in Advance,
>
> Guruprasath B

David Fitzjarrell Received on Wed Feb 06 2008 - 10:49:47 CST