CREATE OR REPLACE PROCEDURE emp_proc_insert IS
tmpVar NUMBER;
BEGIN
tmpVar := 0;
while tmpVar <100
loop
insert into emp(empno) values (tmpVar);
dbms_output.put_line('now number:' || tmpVar);
tmpVar:=tmpVar+1;
end loop;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END emp_proc_insert;