title: How can I process checkbox items from an Oracle APEX report?
body: <p>I am not an experienced APEX developer, hence this problem: I have a report with a few columns, the first one displays a checkbox whose value is the column ID for the row record,  and I need to run a pl/sql function for each row checked but I have had no luck...</p>
  
  <p>The relevant columns' SQL looks something like this (trimmed for the sake of simplicity):</p>
  
  <pre><code>SELECT
    apex_item.checkbox(1, p.ticket_id,'UNCHECKED') "Add",
    p.ticket_id,
    UPPER(SUBSTR(p.status_code, 1, 3)) status,
    p.last_update
  FROM problems p
  ... etc.
  </code></pre>
  
  <p>The first column is set to render as a "Simple Checkbox" and its got #TICKET_ID# for its List Of Value parameters. I have a submit button set to just submit the page, and I have created a process that runs "On submit - after computations and validations" whose executed code is the following PL/SQL:</p>
  
  <pre><code>BEGIN
    FOR i in 1..APEX_APPLICATION.G_F01.COUNT LOOP
      BEGIN
        IF APEX_APPLICATION.G_F01(i) IS NOT NULL THEN
        run-some-procedure-function(
          parameter_one =&gt; APEX_APPLICATION.G_F01(i),
          parameter_two =&gt; :SOME_VALUES_ID,
          parameter_three =&gt; :F_AU_ID
        );
        END IF;
        EXCEPTION WHEN DUP_VAL_ON_INDEX THEN NULL;
      END;
    END LOOP;
  END;
  </code></pre>
  
  <p>When I run this App, mark some checkboxes, and hit the submit button I end up with an error message and a weird URL ending:</p>
  
  <p><img src="https://i.stack.imgur.com/BgdPk.jpg" alt="APEX Error on submit with checkbox values"></p>
  
  <p>Any ideas and/or suggestions are welcome, even a different approach to my problem (I just need to stick to checkboxes because I need that) is accepted.</p>