Cursor is opened at the beginning of the for loop, navigated row at a
time each iteration of the loop then closed at the end of the for loop.
kb wrote:
> Hi guys/gals.
> If I have a piece of code that declares a cursor, and then a piece of code
> that calls it in a For Loop statement,
>
> CURSOR xx
> Select....etc...
> xxx
>
>
> FOR <whatever> in <CURSOR> LOOP
> xx
> xx
> xx
> ENDLOOP
>
> My question is, does the Cursor get run once, returning a list that the FOR
> LOOP code then loops through, or is the cursor actually called over and over
> again by the FOR statement?
> Sorry for the rookie question!!! Thanks!
>
>
Received on Thu Dec 18 2003 - 01:38:59 CST
