Rem drv: <create type="triggers" pos="ecm/ecm_triggers.sql+"/>
Rem
Rem $Header: group_triggers.sql 01-jul-2005.22:01:43 gsbhatia Exp $
Rem
Rem group_triggers.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      group_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    gsbhatia    07/01/05 - New repmgr header impl 
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    gsbhatia    02/13/05 - updating repmgr header 
Rem    gsbhatia    02/09/05 - updating repmgr header 
Rem    gsbhatia    02/07/05 - updating repmgr header 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    ramalhot    08/25/04 - cutover to new assoc tables 
Rem    ramalhot    07/27/04 - code for target assoc added 
Rem    streddy     10/15/03 - Check for group membership 
Rem    streddy     10/09/03 - move metric dependency code from after trigger 
Rem                           to before trigger 
Rem    streddy     09/25/03 - Added type_meta_ver for rep metrics 
Rem    streddy     09/22/03 - Added flat memberships table 
Rem    streddy     08/04/03 - Comment out group_history mgmt 
Rem    streddy     06/30/03 - Add cluster membership association
Rem    streddy     04/22/03 - Support top-down membership composition
Rem    streddy     03/28/03 - Metric dependency changes for composites
Rem    rpatti      12/18/02 - fix perf
Rem    rpinnama    05/14/02 - rpinnama_reorg_rep_scripts
Rem    rpinnama    05/14/02 - Created
Rem

CREATE OR REPLACE TRIGGER memberships_insert_trigger
INSTEAD OF INSERT ON MGMT_TARGET_MEMBERSHIPS FOR EACH ROW
BEGIN
  em_assoc.insert_memberships(:new.composite_target_name,
                              :new.composite_target_type,
                              :new.composite_target_guid,
                              :new.member_target_name,
                              :new.member_target_type,
                              :new.member_target_guid);

END;
/
show errors;