Oracle Trigger ???

68930089

想新增一個trigger 在寫入特定資料後，刪除某特定條件資料列，Ｔrigger 語法如下
一直無法成功請問一下是那裡有問題呢?



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;