Re: Confusion with for loop

> 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?

You have forgotten to end the update statement with a semicolon  

 		 UPDATE USER_DEF SET Dvol = 'BI-DFS01\DFS' WHERE Username
 		 = Username_rec.Username;
                            ^

hth
Rene                             

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch