create procedure thisupdate(Vgroup in varchar2(4), Vflag out integer) is begin savepoint s1; update group set open=0 where group:=Vgroup; update user set open=0 where group:=vgroup; commit; vflag:=1; return; exception when others then rollback to savepoint s1; Vflag:=0; return; end thisupdate 这是我用oracle的大体就是这样的
Vflag out integer) is
begin
savepoint s1;
update group set open=0 where group:=Vgroup;
update user set open=0 where group:=vgroup;
commit;
vflag:=1;
return;
exception
when others then
rollback to savepoint s1;
Vflag:=0;
return;
end thisupdate
这是我用oracle的大体就是这样的