Re: PLS/SQL: OK to use EXIT in a cursor FOR LOOP ??

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?

Well spotted....I have never tried...

I aint near my db at the moment - Try sql%rowcount and let me know ?

Cheers

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."