Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: cursor looping - best practices?

Re: cursor looping - best practices?

From: <spacemarine_at_mailinator.com>
Date: Fri, 15 Jun 2007 12:43:39 -0700
Message-ID: <1181936619.991709.219090@c77g2000hse.googlegroups.com>


On Jun 15, 12:30 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> The code you cite is, well, OLD code. I haven't written a loop like
> that in years, what with the FOR and WHILE constructs available:
>
> FOR myrec IN cursor LOOP
> .... processing here
> END LOOP;
>
> No manual checking for the end of the data, no manual exit strategy.
>
> For array processing a concise set of examples can be found at:
>
> http://www.psoug.org/reference/array_processing.html

...great, i will check that out. thanks

sm Received on Fri Jun 15 2007 - 14:43:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US