比如TRIGGER
[PHP]
CREATE OR REPLACE TRIGGER strategy_member_d
AFTER DELETE
ON strategy_member
FOR EACH ROW
--DECLARE
--PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO strategy_log
(StrategyId,
OldValueId,
TS,
TSUserId)
SELECT :OLD.StrategyId,
:OLD.ObjId,
getdate(),
s.TSUserId
FROM strategy s
WHERE :OLD.StrategyId = s.StrategyId;
END strategy_member_d;
[/PHP]
其中strategy_member有一个strategy的关键删除外键
[php]
alter table STRATEGY_MEMBER
add constraint IF1_STRATEGY_MEMBER foreign key (STRATEGYID)
references STRATEGY (STRATEGYID) on delete cascade;
[/php]
执行
[PHP]DELETE STRATEGE;[/PHP] 会报ORA-04091等错误,大家是怎么解决的?
|