高分求一个触发器,请高手赐教!谢谢!
作用是监控A表中A1字段,当A1字段的值<0时,执行存储过程B(b1 in varchar2,
b2 in varchar2,
b3 in varchar2,
b4 in varchar2)请赐教!谢谢!
作用是监控A表中A1字段,当A1字段的值<0时,执行存储过程B(b1 in varchar2,
b2 in varchar2,
b3 in varchar2,
b4 in varchar2)请赐教!谢谢!
BEFORE INSERT OR UPDATE
ON SCOTT.A
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN if :NEW.a1 < 0
execute immediate 'call B(''aa'' ,''bb'' ,''cc'' ,''dd'')'; EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END trigger1;/
If :old.a1<0 Then
B('aa','bb','cc','dd');
end if;