怎么在循环中处理异常oracle:Cursor a; for a_1 in a loop ...exception ...end loop
问题描述:
怎么在循环中处理异常oracle:Cursor a; for a_1 in a loop ...exception ...end loop
Cursor a;
for a_1 in a loop
...
exception when others then
...
end loop
能这写报错,但是要处理循环体里面的出错记录,
答
在loop里面再加个begin end;
for a_1 in a loop
BEGIN
...
exception when others then
...
END;
end loop