procedure p_insert_test is
--自治事务 同一个存储过程的commit才生效
pragma autonomous_transaction;
begin
insert into test_acc(code1,num1) values('123456789','test');
commit;
end p_insert_test;
procedure p_insert is
v_num number;
begin
--调用
p_insert_test;
-- pragma autonomous_transaction; 不会生效
--commit;
v_num:=10/0;
exception
when others then
dbms_output.put_line(sqlerrm);
-- pragma autonomous_transaction; 不会回滚
rollback;
end p_insert;