Rem drv:
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 -
Rem
Rem DESCRIPTION
Rem
Rem
Rem NOTES
Rem
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;