declare
v_id number; v_desc varchar2(256);
begin
v_id := 0;
while v_id <= 10 loop
v_desc := v_id||'测试';
begin
insert into test_err1(err1,errdesc)
values(v_id,v_desc);
commit;
exception
when others then
dbms_output.put_line(sqlcode||sqlerrm);
end;
v_id := v_id + 1;
end loop;
exception
when others then
dbms_output.put_line(sqlcode||sqlerrm);
end;