通过在触发器中建立自治事务解决ORA-04091(不能读取被触发的表)

create table t1(id number,nm varchar2(100));
create table t2(id number,nm varchar2(100));

 
insert into t2 values(1,'n1');

 
CREATE OR REPLACE TRIGGER test
  before update ON t1
  FOR EACH ROW
declare
  <strong>PRAGMA AUTONOMOUS_TRANSACTION;
</strong>BEGIN
  insert into t2
    select * from t1 where id = :old.id;
  commit;
END;

 
update t1 set t1.id=10 where t1.id=1;

 
commit;