Re: Confusion with for loop

From: Steve Holdoway <steve_at_itemfront.ltd.uk>
Date: Thu, 9 Oct 2003 09:26:37 +0000 (UTC)
Message-ID: <0paaovokg3coe26aumehjich5gqf0927b7@4ax.com>

It might be worth making sure username is always spelt with a capital U at the beginning???

Steve
On Thu, 9 Oct 2003 10:35:26 +0200, Marc Eggenberger <marc.eggenberger_at_itc.alstom.com> 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?
Received on Thu Oct 09 2003 - 04:26:37 CDT