触发帮助 [英] Trigger Help

问题描述

此触发器有什么问题，当我运行此触发器时，出现以下错误.触发重新验证失败.我想确认此触发器是否正确?或者我该如何重写这个

What is wrong with this trigger When i run this i got the following error..TRIGGER REVALIDATION FAILED. i want to confirm this trigger is correct or not? or how i can i re-write this one

CREATE OR REPLACE TRIGGER ERPTRAIN.TRG_MERCH_CUST_CHECK
BEFORE INSERT
ON ERPTRAIN.OM_MERCH_CUST
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW

DECLARE

  N_MC_CUST_CODE Varchar2(10);


BEGIN
  -- your code here
  -- (Trigger template "Default" could not be loaded.)




        If OM_MERCH_CUST.MC_TO_DT. IS Null

             SELECT OM_MERCH_CUST.MC_CUST_CODE,OM_MERCHINDISER_COMP_DIVN.MCD_DIVN_CODE
        FROM OM_MERCH_CUST, OM_MERCHINDISER_COMP_DIVN
        WHERE(OM_MERCH_CUST.MC_CUST_CODE = 111010)
        And OM_MERCHINDISER_COMP_DIVN.MCD_SYSID = OM_MERCH_CUST.MC_MCD_SYSID
        AND OM_MERCHINDISER_COMP_DIVN.MCD_COMP_CODE = '001' AND OM_MERCHINDISER_COMP_DIVN.MCD_DIVN_CODE = '01'
        AND ((OM_MERCH_CUST.MC_FM_DT >= TO_DATE('01-nov-2010 12:00:00 AM','DD-MON-YYYY HH12:MI:SS AM') AND OM_MERCH_CUST.MC_TO_DT Is Null ) OR OM_MERCH_CUST.MC_TO_DT Is Null)

       Else

                SELECT OM_MERCH_CUST.MC_CUST_CODE,OM_MERCHINDISER_COMP_DIVN.MCD_DIVN_CODE
        FROM OM_MERCH_CUST, OM_MERCHINDISER_COMP_DIVN
        WHERE(OM_MERCH_CUST.MC_CUST_CODE = 111010)
        And OM_MERCHINDISER_COMP_DIVN.MCD_SYSID = OM_MERCH_CUST.MC_MCD_SYSID
        AND OM_MERCHINDISER_COMP_DIVN.MCD_COMP_CODE = '001' AND OM_MERCHINDISER_COMP_DIVN.MCD_DIVN_CODE = '01'
        AND (OM_MERCH_CUST.MC_FM_DT >= TO_DATE('01-nov-2010 12:00:00 AM','DD-MON-YYYY HH12:MI:SS AM') AND    OM_MERCH_CUST.MC_TO_DT <= TO_DATE('30-nov-2010 12:00:00 AM','DD-MON-YYYY HH12:MI:SS AM'))


EXCEPTION

    WHEN DATA FOUND

    raise application_error("This Record Already Exist");



END TRG_MERCH_CUST_CHECK;
/

推荐答案

我不是Oracle专家..但试图根据错误找出答案...找到了一个链接...认为它可以帮助您

http://www.dba-oracle.com/sf_ora_04098_trigger_string_string_is_invalid_and_failed_re_validation<.htm

I''m not an Oracle guy..but tried to find out based on the error...found a link...thought it may can help you

http://www.dba-oracle.com/sf_ora_04098_trigger_string_string_is_invalid_and_failed_re_validation.htm[^]

这篇关于触发帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！