Re: REF CURSOR

On Feb 6, 11:49 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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

care to give an example of how to and how not to handle cursors in perl? Received on Wed Feb 06 2008 - 11:05:54 CST