Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PLS/SQL: OK to use EXIT in a cursor FOR LOOP ??
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 - 07:23:41 CDT