Counter does not work in the procedure

[shyamal]

Hi,

For this stored procedure, I cannot make the counter work, any ideas? The table becomes populated with five 1's what I want is that the table is populated with 1,2,3,4,5.

DECLARE
i INTEGER := 1;
BEGIN
WHILE (i <= 5)
LOOP
insert into SLEONARD.T00 (RECID) values (1);
COMMIT;
insert into SLEONARD.T50 (RECID) values (1);
COMMIT;
i := i + 1;
END LOOP;
END;

 

[did02]

Hi,

In your insert statements, the value should be i (not 1)... )

Rgds,
Did02