CREATE OR REPLACE TRIGGER SUMMARY.TRG_WIP_DAILY
AFTER INSERT
ON SUMMARY.TEST_WIP_DAILY
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
tmpVar NUMBER;
/******************************************************************************
NAME: TRG_WIP_DAILY_TRI
PURPOSE:
REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2015/10/19 adm 1. Created this trigger.
NOTES:
Automatically available Auto Replace Keywords:
Object Name: TRG_WIP_DAILY_TRI
Sysdate: 2015/10/19
Date and Time: 2015/10/19, 下午 04:47:16, and 2015/10/19 下午 04:47:16
Username: adm (set in TOAD Options, Proc Templates)
Table Name: TRG_WIP_DAILY (set in the "New PL/SQL Object" dialog)
Trigger Options: (set in the "New PL/SQL Object" dialog)
******************************************************************************/
BEGIN
DELETE SUMMARY.TEST_WIP_DAILY SET WIP=0 WHERE OPERATION IN ('WA','WB');
EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END TRG_WIP_DAILY;