0 Replies Latest reply: Aug 29, 2013 5:05 AM by malhi RSS

    Applying conflict handlers on one table

    malhi

      I create following update conflict handlers, one after other. These are working correctly, my problem is when i create 2nd it replace first one, and when i create 3rd one it replace 2nd one. I want to put all three in action simultaneously. How can i do this.

       

       

      {code}

      DECLARE

      cols DBMS_UTILITY.NAME_ARRAY;

      BEGIN

      cols(1) := 'MODIFIED_DATE';

      cols(2) := 'MODIFIED_BY';

      cols(3) := 'RATE_CHANGE_DATE';

      cols(4) := 'PENSION_AMOUNT';

      cols(5) := 'EASYPAISA_WORK_ON';

      cols(6) := 'PPO_NO';

      cols(7) := 'NEW_NIC_NO';

      cols(8) := 'OLD_NIC_NO';

      cols(9) := 'CLAIM_NO';

      DBMS_APPLY_ADM.SET_UPDATE_CONFLICT_HANDLER(

      object_name => 'CORE_BUSINESS.CB_PENSIONER',

      method_name => 'OVERWRITE',

      resolution_column => 'CLAIM_NO',

      column_list => cols);

      END;

      {code}

       

       

      {code}

      DECLARE

      cols DBMS_UTILITY.NAME_ARRAY;

      BEGIN

      cols(1) := 'MODIFIED_DATE';

      cols(2) := 'MODIFIED_BY';

      cols(3) := 'RATE_CHANGE_DATE';

      cols(4) := 'PENSION_AMOUNT';

      cols(5) := 'CLAIM_NO';

      DBMS_APPLY_ADM.SET_UPDATE_CONFLICT_HANDLER(

      object_name => 'CORE_BUSINESS.CB_PENSIONER',

      method_name => 'OVERWRITE',

      resolution_column => 'CLAIM_NO',

      column_list => cols);

      END;

      {code}

       

      {code}

      DECLARE

      cols DBMS_UTILITY.NAME_ARRAY;

      BEGIN

      cols(1) := 'EASYPAISA_WORK_ON';

      cols(2) := 'CLAIM_NO';

      DBMS_APPLY_ADM.SET_UPDATE_CONFLICT_HANDLER(

      object_name => 'CORE_BUSINESS.CB_PENSIONER',

      method_name => 'OVERWRITE',

      resolution_column => 'CLAIM_NO',

      column_list => cols);

      END;

      {code}