ORA-01044: size 24608017 of buffer bound to variable exceeds maximum o number conversion errorr to number conversion error

procedure SetClientsID
  (
    p_session_id in varchar2,
    p_clob       in clob,
    p_delimiter  in varchar2 default ':'
  ) is
    pragma autonomous_transaction;
    l_counter  number default 0;
    l_pos      number default 1;
    l_last_pos number default 1;
    l_val      number;
    l_amount   number;
    l_clob     clob;
  begin
    pk_log.Flush;
    pk_log.InitDefaultContext(PTypeId => 1200, PSection => 'SetClientsID');
    pk_log.Info('SetClientsID...');
    l_clob := p_clob;
    dbms_lob.writeappend(l_clob, 1, p_delimiter);
    loop
      l_counter := l_counter + 1;
      pk_log.Info(util.Format('counter = "%d"', l_counter));
      l_pos := dbms_lob.instr(l_clob, p_delimiter, 1, l_counter);
      exit when(l_pos = 0);
    
      l_pos := l_pos + 1;
      l_amount := l_pos - l_last_pos - 1;
      l_val := dbms_lob.substr(l_clob, l_amount, l_last_pos);
      l_last_pos := l_pos;
      pk_log.Info(util.Format('value = "%s"', l_val));
    
      insert into REPORT_CLNT_IDS
        (CLNT_ID, SESSION_ID)
      values
        (l_val, p_session_id);
    end loop;
    pk_log.Info('SetClientsID - Ok');
    pk_log.Flush;
    commit;
  exception
    when others then
      pk_log.Error('SetClientsID - Error');
      pk_log.Flush;
      rollback;
      raise;
  end;

procedure ClearClientsID(p_session_id in varchar2) is
    pragma autonomous_transaction;
  begin
    delete from REPORT_CLNT_IDS rci
     where rci.session_id = p_session_id;
    commit;
  end;

BEGIN
  :P10_SESSION_ID := :P10_SESSION_ID || '_' || to_char(current_timestamp, 'YYYYMMDDHH24MISSFF3');
  if :P10_CLIENT_TP = 'I' then
    apx_jri_util.SetClientsID(p_session_id => :P10_SESSION_ID, p_clob => :P10_CSO);
  else
    apx_jri_util.SetClientsID(p_session_id => :P10_SESSION_ID, p_clob => :P10_CLIENT_ID);
    apx_jri_util.SetOwnersID(p_session_id => :P10_SESSION_ID, p_clob => :P10_OWNERS);
  end if;
  xlib_jasperreports.set_report_url( :P10_WEB||'/jri/report' );
  xlib_jasperreports.show_report (p_rep_name => 'RRO-loaded-data-volume',
          p_rep_format          => :P10_FORMAT,
          p_data_source         => :P10_REPORT_ALIAS,
          p_out_filename        => 'RRO-'||:p10_from_date||'-'||:p10_to_date||'.'||:p10_format,
          p_rep_locale          => 'ru_UA',
          p_rep_encoding        => 'UTF-8',
          p_additional_params => 'p_from_date=' || :P10_FROM_DATE || '&p_to_date=' ||
                                                        :P10_TO_DATE || '&p_clnt_tp=' || :P10_CLIENT_TP ||
                                                        '&p_session_id=' || :P10_SESSION_ID);

  apex_application.g_unrecoverable_error := true;
  apx_jri_util.ClearClientsID(p_session_id => :P10_SESSION_ID);
  apx_jri_util.ClearOwnersID(p_session_id => :P10_SESSION_ID);
end;

insert into REPORT_CLNT_IDS
        (CLNT_ID, SESSION_ID - не нужно)
      values
        (l_val, p_session_id - не нужно);