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;