17,140
社区成员




create procedure pro_a_testlogrollback as
v_val number;
begin
insert into a_testdata values(3);
v_val := 1/0;
exception
when others then
rollback;
insert into a_testlog values(sysdate,'异常操作已经回滚');
commit;
end;