[oracle] 프로시저 loop돌리기

--loop문
create or replace procedure loop_test(i in integer)
is
    p_i number default 1000;
    p_max number;
begin
    p_max := p_i+i;
    LOOP
        insert into emp(empno, ename) values(p_i, 'A'||p_i);
        p_i := p_i +1;
    exit when p_i >p_max;
    END LOOP;
end;

execute loop_test(5);