最近把一个SQL库转为ORACLE,随之而来的问题也来了,就是原来的触发器,不能用,我上午弄了很久也不行实现功能是这样的,有一个字段字段为LONG型例(E),要在新增/修改的时候把这条记录的其他字段,例:A,B,C,D组合起来,(A为主键)我写的如下:不知道错在哪里一直不明白,请高手解答CREATE OR REPLACE TRIGGER FWDJ_CountTigger
AFTER insert or update
of A,B,C,D On FWDJ
for each row
declare
pragma autonomous_transaction;
begin
update FWDJ Set E=A+B+C+D Where A=:new.ArchiveID;
commit;
end;
AFTER insert or update
of A,B,C,D On FWDJ
for each row
declare
pragma autonomous_transaction;
begin
update FWDJ Set E=A+B+C+D Where A=:new.ArchiveID;
commit;
end;
CREATE OR REPLACE TRIGGER FWDJ_COUNTTIGGER
AFTER INSERT OR UPDATE OF A, B, C, D ON FWDJ
FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
UPDATE FWDJ SET E = A || B || C || D WHERE A = :NEW.ARCHIVEID;
COMMIT;
END;
/