诊断代码
触发器
create or replace trigger TRI_Delete_Deal
after update of Arr_Date on Deal
for each row
Begin
delete from Deal where Deal_ID=:old.Deal_ID;
End;
在执行Arr_Date更新时出现错误:
update deal set arrival_date ='2003-11-04' where deal_id=2
*
ERROR 位于第 1 行:
ORA-04091: 表 SMILE.DEAL 发生了变化,触发器/函数不能读
ORA-06512: 在"SMILE.TRI_DELETE_DEAL", line 2
ORA-04088: 触发器 'SMILE.TRI_DELETE_DEAL' 执行过程中出错
??