PL/SQL Questions.

From: Anthony Scott <ascott_at_interaccess.com>
Date: Sun, 29 Jul 2001 11:45:41 -0500
Message-ID: <3B643DB5.E34DD940@interaccess.com>

Can anyone tell me why the following code doesn't produce the desire  results?

 BEGIN
    FOR x IN 1..3 LOOP

       update users set testid = x;
       DBMS_OUTPUT.PUT_LINE(x);

    END LOOP;
 END;  output to sqlplus is : 1

                        2
                        3

 output in testid is   : 3
                         3
                         3

 RH 6.1
 Oracle 8.1.6

 Tony Received on Sun Jul 29 2001 - 11:45:41 CDT