oracle如何在触发器执行带参数的存储过程
发布网友
共1个回答
热心网友
把exec去了。直接调用
CREATE OR REPLACE TRIGGER TRU_WORKSAL
AFTER UPDATE OR DELETE
ON WORKSAL
FOR EACH ROW
DECLARE CALC DATE;
BEGIN
pad_amt(:new.salmonth,:new.staff);
pad_sal(:new.salmonth,:new.staff);
END;
/
