通过在触发器中建立自治事务解决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 ROWdeclare  <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;