begin
stoo_rowcnt:=0
update table 1 set sdfd=....;
stoo_rowcnt:=sql%rowcount;
exception
when others then
continue_flag:=false;
end;
if stoo_rowcnt=0 then
continue_flag:=false;
end if;
if continue_flag then
update table 2....
end if;
declare
v1 number;
v2 number;
v3 number;
begin
update ....;
v1:=sql%rowcount;
update....;
v2:=sql%rowcount;
update....;
v3:=sql%rowcount;
commit;
if v1=0 or v2=0 or v3=0 then
rollback;
end if;
end;
/