for ... loop
begin
insert into tbname values(...);
exception when others then
insert into tberrorlog values...;
end;
end loop;
...
begin
insert into tbname values(...);
exception when others then
insert into tberrorlog values...;
end;
end loop;
...
for ... loop
begin
insert into tbname values(...);
commit;
exception
when others then
insert into tberrorlog values...;
end;
end loop;
--commit; <---如果把commit写在这里,在提交的时候如果出错就捕捉不到错误了.
...VC的前端来取数据表的数据吧.
返回ref cursor游标