触发器有问题么?
CREATE OR REPLACE TRIGGER "S-DEW"."STORYCANDIDACY_UPDATE" AFTER
UPDATE OF GRADE_CHENC, GRADE_ANNIE, GRADE_LIXH, GRADE_NINGCS
ON "S-DEW"."STORYCANDIDACY"
FOR EACH ROW
BEGIN
UPDATE STORYCANDIDACY
SET STORYCANDIDACY.GRADE_SUM = (:NEW.GRADE_CHENC + :NEW.GRADE_ANNIE + :NEW.GRADE_LIXH + :NEW.GRADE_NINGCS)
WHERE (STORYCANDIDACY.STORYID = :NEW.STORYID);
END;
触发器已创建
UPDATE STORYCANDIDACY SET GRADE_CHENC = GRADE_CHENC+0
*
ERROR 位于第 1 行:
ORA-04091: 表 S-DEW.STORYCANDIDACY 发生了变化,触发器/函数不能读
ORA-06512: 在"S-DEW.STORYCANDIDACY_UPDATE", line 2
ORA-04088: 触发器 'S-DEW.STORYCANDIDACY_UPDATE' 执行过程中出错