怎么在循环中处理异常oracle:Cursor a; for a_1 in a loop ...exception ...end loopCursor a; for a_1 in a loop...exception when others then ...end loop能这写报错,但是要处理循环体里面的出错记录,

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/04 06:52:30

怎么在循环中处理异常oracle:Cursor a; for a_1 in a loop ...exception ...end loopCursor a; for a_1 in a loop...exception when others then ...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
能这写报错,但是要处理循环体里面的出错记录,

怎么在循环中处理异常oracle:Cursor a; for a_1 in a loop ...exception ...end loopCursor 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