行级触发器不允许更新自身表
可用自治事务
Create Or Replace Trigger TPV_PANEL_INFO_OLD_ID
After Insert on TPV_PANEL_INFO_OLDfor Each Row
pragma autonomous_transaction;
TKIND Varchar2(50); --变量begin Select THEKIND Into TKIND From OTHERTABLE Where THENAME=:New.NAME And THEAGE=:New.AGE;
Update tpv_panel_info Set KIND=TKIND Where ID = :New.ID;
commit;
End;
可用自治事务
Create Or Replace Trigger TPV_PANEL_INFO_OLD_ID
After Insert on TPV_PANEL_INFO_OLDfor Each Row
pragma autonomous_transaction;
TKIND Varchar2(50); --变量begin Select THEKIND Into TKIND From OTHERTABLE Where THENAME=:New.NAME And THEAGE=:New.AGE;
Update tpv_panel_info Set KIND=TKIND Where ID = :New.ID;
commit;
End;
但是又有一个奇怪的问题 按照您的写法没有包错 但是为什么就是没有UPDATE呢
:New.ID和TKIND这2个值我都取道了
如果我换成Update tpv_panel_info Set KIND=TKIND Where ID = 2; 或者
Update tpv_panel_info Set KIND=:New.ID Where ID = 2; 都是可以的
但是就是Update tpv_panel_info Set KIND=TKIND Where ID = :New.ID;
没反映 为什么呢?