如果表ORG_CORP_TREE中的字段ORGBCFL、ORGNAME、ORGSCFL发生变化时,触发器SELECT COUNT(*) INTO ORGNUM FROM ORG_CORP_TREE; 这个触发器该如何写呢?
我的也是when inserting then insert into B@REP remote select * from A where a13 = :new.a13报错ORA-04091:表A发生了变化,触发器/函数不能读,ORA-04088:触发器执行过程中出错。怎么回事呢?A,B结构完全一样
create table t1 as SELECT * FROM ORG_CORP_TREE;CREATE OR REPLACE TRIGGER TRI_REPORT_ORGTREETEMP_UPD AFTER UPDATE ON ORG_CORP_TREE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLAREORGNUM INTEGER;BEGIN SELECT COUNT(*) INTO ORGNUM FROM t1;
这个触发器该如何写呢?
AFTER UPDATE ON ORG_CORP_TREE
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLAREORGNUM INTEGER;BEGIN SELECT COUNT(*) INTO ORGNUM FROM t1;
END;