Skip to Content
0

how to insert a values using for loop in procedure?

Aug 21, 2017 at 07:26 AM

13

avatar image

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;


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers