Oracle Apex Shuttle Item Array empty on submit
<p>I'm trying to save values from a Shuttle Item into a table. The values for the Shuttle item are taken from an LOV, with Names as Display values and ID's as return values. </p>

<p>However the array I'm creating remains empty after saving, and so the length is always 0, no matter how many items I'm selecting.</p>

<p>The PL/SQL code for storing the items is:</p>

<pre><code>DECLARE 
diagnostic NUMBER;
l_selected apex_application_global.vc_arr2;

BEGIN
diagnostic := ID_DIAG_OPHT_SEQ.NEXTVAL;
l_selected := apex_util.string_to_table(:P205_SHUTTLE);

for i in 1..l_selected.count loop
    insert into DIAG_OPHT_LIST(ID_DIAG_OPHT, ID_LIST_OPHT)
    values (diagnostic, l_selected(i));
end loop;
end;
</code></pre>

<p>When I'm inserting a fix value ('3:7:25:45:') instead of ':P205_AJ_PATHOLOGIE' everything works fine.</p>

<p>In the item properties themselves I left everything as standard. As I said, I'm using a named LOV and Source used is 'Only when current value in Session state is null' and Source Type is 'Static assignment'.</p>

<p>Thanks in advance for any help </p>