我猜你问的是在游标操作中的问题吧?那有很多种处理方式,比如
FOR REC IN MY_CURSOR LOOP
EXIT WHEN ....;
...;
IF MY_CONDITION THEN --满足条件的情况下执行下列语句,否则不执行
...;
END IF;
END LOOP;
FOR REC IN MY_CURSOR LOOP
EXIT WHEN ....;
...;
IF MY_CONDITION THEN --满足条件的情况下执行下列语句,否则不执行
...;
END IF;
END LOOP;
IF ... THEN CONTINUE --跳出本次循环
..
END LOOP
加一条Fetch不知道是不是要这样
Fetch mycursor into v_a1,v_a2;
if ...then continue;
exit when mycursor%notfound;
end loop
Fetch mycursor into v_a1,v_a2;
exit when mycursor%notfound;
if ...then continue;
end loop
loop
exit when c%notfound;
...
savepoint save1;
if ... then
rollback to save1;
fetch a into v_a;
end if;
end loop;
loop
exit when c%notfound;
...
savepoint save1;
if ... then
rollback to save1;
fetch a into v_a;
end if;
fetch a into v_a;-----漏掉了.
end loop;sorry!漏掉一句!!!