发布网友 发布时间:2022-04-24 12:06
共1个回答
热心网友 时间:2022-04-09 18:21
把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;
/