不好意思,我写了一个;CREATE TRIGGER DOCU_TRIGER BEFORE DELETE ON "DOCU_INDEX" begin insert into docuindex_log(dl_time,dl_policy_no,dl_docu_id)values(sysdate,:new.di_policy_no,:new.di_docu_id); end docu_triger;可是系统说:new和old引用不允许在表层触发器中 为什么啊?????
对呀?只是DELETE操作呀?你没有说清楚吧?请详细描述你的需求!!
CREATE TRIGGER DOCU_TRIGER BEFORE DELETE ON "DOCU_INDEX " for each row begin insert into docuindex_log(dl_time,dl_policy_no,dl_docu_id)values(sysdate,:new.di_policy_no,:new.di_docu_id); end docu_triger;
跟列有什么关系
DELETE ON "DOCU_INDEX" begin
insert into docuindex_log(dl_time,dl_policy_no,dl_docu_id)values(sysdate,:new.di_policy_no,:new.di_docu_id);
end docu_triger;可是系统说:new和old引用不允许在表层触发器中
为什么啊?????
BEFORE DELETE ON "DOCU_INDEX "
for each row
begin
insert into docuindex_log(dl_time,dl_policy_no,dl_docu_id)values(sysdate,:new.di_policy_no,:new.di_docu_id);
end docu_triger;