怎么在循环中处理异常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