pragma autonomous_transaction

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;