plsql oracle怎么回滚,PLSQL异常中的回滚

想知道在检测到SQL异常(其他人的异常)时是否需要回滚：

declare

cursor c_test is

select *

from tesing;

begin

for rec in c_test loop

begin

update test1 set test1.name=rec.name where test1.id=rec.id;

IF sql%rowcount = 1 THEN

commit;

ELSIF sql%rowcount =0 THEN

dbms_output.put_line('No Rows Updated');

else

dbms_output.put_line('More than 1 row exists');

rollback;

END IF;

exception when others then

dbms_output.put_line(Exception');

rollback;

end;

end;