create or replace
TRIGGER GPM_NODEINSTANCE_TRG
AFTER INSERT OR UPDATE OF STATUS ON GPM_NODEINSTANCE_TBL
FOR EACH ROW
DECLARE
P_STATUS NUMBER;
P_BUST_ID NUMBER;
BEGIN
--新增
IF inserting
THEN
SELECT I.GPM_BUSINESS_ID INTO P_BUST_ID FROM GPM_INSTANCE_TBL I WHERE I.GPM_INSTANCE_ID=:new.GPM_INSTANCE_ID;
PKG_IFACE_FOR_FLOW.CustOrderEnd(P_BUST_ID); --调用包中的存储过程(包名+存储过程名+参数)
END IF;
END GPM_NODEINSTANCE_TRG;
TRIGGER GPM_NODEINSTANCE_TRG
AFTER INSERT OR UPDATE OF STATUS ON GPM_NODEINSTANCE_TBL
FOR EACH ROW
DECLARE
P_STATUS NUMBER;
P_BUST_ID NUMBER;
BEGIN
--新增
IF inserting
THEN
SELECT I.GPM_BUSINESS_ID INTO P_BUST_ID FROM GPM_INSTANCE_TBL I WHERE I.GPM_INSTANCE_ID=:new.GPM_INSTANCE_ID;
PKG_IFACE_FOR_FLOW.CustOrderEnd(P_BUST_ID); --调用包中的存储过程(包名+存储过程名+参数)
END IF;
END GPM_NODEINSTANCE_TRG;