Forum Stats

  • 3,814,159 Users
  • 2,258,828 Discussions
  • 7,892,596 Comments

Discussions

Error when add new member. Sqlerrm:ORA-00001: unique constraint violated

Kastus_Kalinouski
Kastus_Kalinouski Member Posts: 8 Green Ribbon

hi all,


I created DA with the next code:

var gridView = apex.region("LoansGrid").widget().interactiveGrid("getViews").grid;

var records = gridView.getSelectedRecords();

var iter = 0;

if (records.length > 0) {

$.each(records, function(i, r) {

      iter = iter +1;

      DATUM = gridView.model.getValue(r, "DATUM");

      INSTITUTSZUORDNUNG = gridView.model.getValue(r, "INSTITUTSZUORDNUNG");

      KONTONUMMER = gridView.model.getValue(r, "KONTONUMMER");

      KUNDENNUMMER = gridView.model.getValue(r, "KUNDENNUMMER");

      apex.server.process("Put_Records_Into_Collection",

        {

          x01: DATUM,

          x02: INSTITUTSZUORDNUNG,

          x03: KONTONUMMER,

          x04: KUNDENNUMMER

        },

        {type: 'GET', dataType: 'text', success: function(pData) { var res = JSON.parse(pData).result; console.log("DA. count of records: " , res);}}

      );

      console.log("continue");      

});

}


Also I created Ajax Callback with the next code:

declare 

  p_count number;

begin

  begin

    if not apex_collection.collection_exists(p_collection_name => 'FOR_CHANGING_ZESSION_WIDMUNG') then

      apex_collection.create_collection('FOR_CHANGING_ZESSION_WIDMUNG');

    end if;

  exception

    when dup_val_on_index then null;

  end;   

  apex_collection.add_member(p_collection_name => 'FOR_CHANGING_ZESSION_WIDMUNG',

               p_generate_md5 => 'YES',

               p_d001 => apex_application.g_x01,

               p_c001 => apex_application.g_x02,

               p_c002 => apex_application.g_x03,

               p_c003 => apex_application.g_x04);

  select count(*)

  into p_count

  from apex_collections

  where collection_name = 'FOR_CHANGING_ZESSION_WIDMUNG';

  apex_json.open_object;   

  apex_json.write('success', true);   

  apex_json.write('result', p_count);   

  apex_json.close_object;  

end;


It works, but when I choose more than 20 records from IG and click button with DA code below there is not all records are put into apex collection. For some records I get error "sqlerrm:ORA-00001: unique constraint (APEX_190200.WWV_FLOW_COLLECTION_MEMBERS_PK) violated".

How to fix the problem?

Tagged: