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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 21 Jun 1999 22:12:46 +0800
Message-ID: <376E485E.8D4@yahoo.com>

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." Received on Mon Jun 21 1999 - 09:12:46 CDT