Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Confusion with for loop
Marc Eggenberger wrote:
>Hi there.
>
>I tried to use an FOR LOOP in an anonymous block (in the SQL Window in
>TOAD to be more specific).
>
>I tried this:
>
>DECLARE
> CURSOR username_cur IS
> SELECT Username FROM omsmaeg.eins;
>
>BEGIN
> FOR Username_rec IN Username_cur
> LOOP
> UPDATE USER_DEF SET Dvol = 'BI-DFS01\DFS' WHERE Username
> = Username_rec.Username
> END LOOP;
> COMMIT;
>END;
>
>
>I used this in procedures already. But now it says me I need to declare
>Username_rec. Isnt this the work of the FOR LOOP to do it implicit?
>
>What am I doing wrong here?
>
>
>
The problem may be your version of TOAD, you don't say, rather than your
code.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Oct 09 2003 - 10:43:54 CDT