Re: PLS/SQL: OK to use EXIT in a cursor FOR LOOP ??
From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Tue, 22 Jun 1999 08:23:41 -0400
Message-ID: <376F804D.CE79E6E6_at_lucent.com>
Date: Tue, 22 Jun 1999 08:23:41 -0400
Message-ID: <376F804D.CE79E6E6_at_lucent.com>
Just tried it. The SQL% doesn't work (it returns null). There probably isn't a way to access cursor attributes if the cursor isn't explicitly declared.
Ken
Connor McDonald wrote:
> Kenneth C Stahl wrote:
> >
> > Connor McDonald wrote:
> > >
> > >
> > > Another nice thing is that you don't even need a cursor...
> > >
> > > for i in ( select my_data, some_more
> > > from my_table ) loop
> > >
> > > blah blah blah
> > > end loop;
> > >
> > > works quite nicely...
> > > --
> >
> > Using that method, how do you access the cursor attributes? %ROWCOUNT
> > for instance?
>
>
Received on Tue Jun 22 1999 - 14:23:41 CEST