how to insert a values using for loop in procedure?

[former_member383962]

hi,

i tried to insert a records using for loop in proceedure but it throuh the error.

this is my code:

Create procedure "KABIL_PRACTICE"."FORLOOP_1" 
as begin
begin
declare i integer;
create column table "KABIL_PRACTICE"."FOR_LOOP_1" ("ID" integer);
for i in 1..10 do
insert into "KABIL_PRACTICE"."FOR_LOOP_1" values(:i);
end for;
end;