CREATE OR REPLACE PROCEDURE testinsertdata IS
----定义变量
i NUMBER;
BEGIN
i:=0;
----循环开始
WHILE (i<5) LOOP
BEGIN
insert into adminlog(n01id,n02adminid,n03content,n04date,n05memo1,n06memo2)
values(seq_adminlog_id.nextval,'003','content3',sysdate,'m1','m2');
commit;
i:=i+1;
END;
----循环结束
END LOOP;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END testinsertdata;
/
存储过程的执行
1.PL/SQL的运行窗口:
call testinsertdata();无参数也要加括号
begin
testinsertdata ;无参数不加括号
end;
2.windowsSQL窗口:
exec testinsertdata ;
execute testinsertdata ;