Rem drv: <create type="post_creation" pos="properties/properties_post_creation.sql-"/>
Rem
Rem $Header: assoc_post_creation.sql 14-jul-2005.03:20:04 gsbhatia Exp $
Rem
Rem assoc_post_creation.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      assoc_post_creation.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/03/05 - New repmgr header impl 
Rem    pmodi       04/15/05 - Add two tables to delete exception list 
Rem    pmodi       02/17/05 - few more tables added in delete exceptions 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    ramalhot    10/08/04 - loader assoc rowset clallbacks added 
Rem    ramalhot    08/18/04 - target pre delete callback registered 
Rem    ramalhot    07/27/04 - handle_relocated_target callback added
Rem    ramalhot    07/21/04 - ramalhot_assoc_sdk
Rem    ramalhot    07/14/04 - Created
Rem
BEGIN
  DECLARE del_exceptions SMP_EMD_STRING_ARRAY := SMP_EMD_STRING_ARRAY();

  BEGIN
    del_exceptions.extend(7);
    del_exceptions(1) := 'MGMT_TARGET_ASSOCS';
    del_exceptions(2) := 'MGMT_FLAT_TARGET_ASSOC';
    del_exceptions(3) := 'MGMT_TARGET_PENDING_ASSOCS';
    del_exceptions(4) := 'MGMT_TARGET_ASSOC_ERROR';
    del_exceptions(5) := 'MGMT_TARGET_ASSOC_PROP';
    del_exceptions(6) := 'MGMT_TARGET_ASSOC_INSTANCE';
    del_exceptions(7) := 'MGMT_TARGET_TEMP_LIST';

    MGMT_ADMIN.add_target_deletion_exceptions(del_exceptions);
    commit;
  EXCEPTION
    WHEN OTHERS 
      THEN 
        dbms_output.put_line( 'EXCEPTION registering delete_exception '|| SQLCODE );
        RAISE;
  END;
END;   
/

show error;

BEGIN
  mgmt_admin.add_target_addition_callback('em_assoc.update_pending_assoc');
  commit;
EXCEPTION
  WHEN OTHERS 
    THEN 
      dbms_output.put_line( 'EXCEPTION registering add_target callback '|| SQLCODE );
      RAISE;
END;
/
show error;

BEGIN
  em_target.add_tgt_pre_deletion_callback('em_assoc.delete_target');
  commit;
EXCEPTION
  WHEN OTHERS 
    THEN 
      dbms_output.put_line( 'EXCEPTION registering  pre_delete_target callback '|| SQLCODE );
      RAISE;
END;
/
show error;
-- Register logging modules.
BEGIN
  mgmt_log.register_logging_module ('ASSOC','Association');

  COMMIT;
END;
/
show error;

BEGIN
  mgmt_target.add_tgt_relocation_callback('em_assoc.handle_relocated_target');
  commit;
EXCEPTION
  WHEN OTHERS 
    THEN 
      dbms_output.put_line( 'EXCEPTION registering handle_relocated_target callback '|| SQLCODE );
      RAISE;
END;
/
show error;

BEGIN
  emd_loader.add_plsql_handler_for_rowset(p_rowset_name => 'MGMT_TARGET_MEMBERSHIPS', p_proc_name => 'em_assoc.add_member_from_loader');
  commit;
EXCEPTION
  WHEN OTHERS
    THEN
      dbms_output.put_line( 'EXCEPTION add handler for membership rowset callback '|| SQLCODE );
      RAISE;
END;
/
show error;

BEGIN
  emd_loader.add_plsql_handler_for_rowset(p_rowset_name => 'MGMT_TARGET_ASSOCS', p_proc_name => 'em_assoc.add_assoc_from_loader');
  commit;
EXCEPTION
  WHEN OTHERS
    THEN
      dbms_output.put_line( 'EXCEPTION add handler for assoc rowset callback '|| SQLCODE );
      RAISE;
END;
/
show error;