请教各位关于oracle触发器的问题!
create or replace trigger tr_for_update_score
after update of ORDER_STATUS on t_bc_shopingorder
referencing old as old_value
new as new_value
for each row
when ((old_value.ORDER_STATUS=1) and (new_value.ORDER_STATUS in('2','3')) and (new_value.score=0))
declare
-- local variables here
begin
--
update t_bc_shopingorder sp --这里报错
set sp.score=1000;
--
update t_bc_customer c
set c.score=c.score+50
where c.id=(:new_value.BUYER_ID);
end tr_for_update_score;
报错地方我已标注自己感觉是因为触发器建立在这个表上然后又更新这个表造成的错误 请高手指点 谢谢
create or replace trigger tr_for_update_score
after update of ORDER_STATUS on t_bc_shopingorder
referencing old as old_value
new as new_value
for each row
when ((old_value.ORDER_STATUS=1) and (new_value.ORDER_STATUS in('2','3')) and (new_value.score=0))
declare
-- local variables here
begin
--
update t_bc_shopingorder sp --这里报错
set sp.score=1000;
--
update t_bc_customer c
set c.score=c.score+50
where c.id=(:new_value.BUYER_ID);
end tr_for_update_score;
报错地方我已标注自己感觉是因为触发器建立在这个表上然后又更新这个表造成的错误 请高手指点 谢谢
http://guanvee.cnblogs.com/archive/2006/06/18/428731.html