Rem drv: <create type="triggers"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/latest/hdm/hdm_triggers.sql /st_emdbsa_11.2/2 2010/02/18 12:55:42 kdas Exp $
Rem
Rem hdm_triggers.sql
Rem
Rem Copyright (c) 2003, 2010, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      hdm_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    kdas        02/16/10 - Backport kdas_bug-8219750 from
Rem                           st_emdbgc_10.2.0.1.0
Rem    kdas        12/03/08 - fix for 4676804
Rem    kdas        09/11/06 - 
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    rpinnama    06/12/04 - Remove SET ECHO 
Rem    nachen      12/05/03 - fix trigger 
Rem    nachen      11/25/03 - fix trigger 
Rem    ychan       10/09/03 - Fix bug 3173816 
Rem    kdas        05/02/03 - bugfix
Rem    kdas        04/30/03 - fix paste issue
Rem    kdas        04/23/03 - kdas_hdm_metric042103
Rem    kdas        04/21/03 - Created
Rem


CREATE OR REPLACE TRIGGER MGMT_DB_HDM_METRIC_TR 
    BEFORE INSERT OR UPDATE 
ON MGMT_DB_HDM_METRIC_HELPER FOR EACH ROW 
BEGIN 
  IF (:new.TARGET_GUID IS NOT NULL) 
  THEN 
      DELETE FROM MGMT_DB_LATEST_HDM_FINDINGS 
       WHERE target_guid = :new.TARGET_GUID 
      AND collection_timestamp < :new.COLLECTION_TIMESTAMP; 
  END IF; 
END; 
/
show errors;