Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\policy\policy

Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\policy\policy_triggers.sql

Rem drv: <create type="triggers" pos="policy/policy_triggers.sql+"/>
Rem
Rem $Header: policy_triggers.sql 28-jul-2005.23:01:04 jsadras Exp $
Rem
Rem policy_triggers.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      policy_triggers.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    jsadras     07/28/05 - add header 
Rem    jsadras     07/16/05 - jsadras_bug-4339821
Rem    jsadras     07/14/05 - Created
Rem

CREATE OR REPLACE TRIGGER em_policy_assoc_cfg_params
   BEFORE INSERT OR UPDATE ON MGMT_POLICY_ASSOC_CFG_PARAMS FOR EACH ROW
WHEN ( 
       TRIM(new.crit_threshold) IS NULL AND
       TRIM(new.warn_threshold) IS NULL AND
       TRIM(new.info_threshold) IS NULL
     )
DECLARE
  l_tbl_metric_guid MGMT_METRICS.metric_guid%TYPE;
BEGIN
 EM_SEVERITY.clear_alerts_for_key
      (p_object_guid=>:new.object_guid,
       p_policy_guid=>:new.policy_guid,
       p_cfg_coll_name=>:new.coll_name,
       p_cfg_key_value=>:new.key_value,
       p_cfg_key_operator=>:new.key_operator
      ) ;

END;
/
show errors;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de