怎么在循环中处理异常oracle:Cursor a; for a_1 in a loop ...exception ...end _其他解答

怎么在循环中处理异常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
能这写报错,但是要处理循环体里面的出错记录,

人气：227 ℃　时间：2020-07-27 15:23:01

解答

在loop里面再加个begin end;
for a_1 in a loop
BEGIN
...
exception when others then
...
END;
end loop