我是这样写的,可是更新不了
CREATE OR REPLACE TRIGGER AA.AA
AFTER INSERT
ON AA.BB
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
PRAGMA autonomous_transaction;
s_id VARCHAR2(20);
BEGIN s_id := :NEW.id;
UPDATE BB SET id2 = s_id WHERE id = s_id;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
RAISE;
END ;
CREATE OR REPLACE TRIGGER AA.AA
AFTER INSERT
ON AA.BB
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
PRAGMA autonomous_transaction;
s_id VARCHAR2(20);
BEGIN s_id := :NEW.id;
UPDATE BB SET id2 = s_id WHERE id = s_id;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
RAISE;
END ;
:NEW.id2 = :NEW.id;
即可。CREATE OR REPLACE TRIGGER AA.trig_before_bb
BEFORE INSERT
ON AA.BB
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLAREBEGIN
:NEW.id2 := :NEW.id;
END ;
/