title: APEX Shuttle - get more values as selected
body: <p>i working since some days with APEX and i added a Shuttle also a text field which contains after processing the selected values.</p>
  
  <p>for the shuttle i have made a LOV (contains stations)
  example:
  Be
  Fd
  Au
  ...</p>
  
  <p>the target is get all object's which contains the selected station's
  but if i run the select i get more objects - also the object which does not contain any selected station, but i don’t know why</p>
  
  <p>in the SQL statement i have the following: (ds_bess001 is the field for stations)</p>
  
  <pre><code>AND INSTR (:P4_BES_EN, zl.ds_bes001) &gt; 0
  </code></pre>
  
  <p>for the shuttle i use PL/SQL below</p>
  
  <pre><code>DECLARE
     v_selected   APEX_APPLICATION_GLOBAL.VC_ARR2;
     v_in_text    VARCHAR2 (500) := '';
  BEGIN
     v_selected := APEX_UTIL.STRING_TO_TABLE (:P4_BES);
  
     FOR i IN 1 .. v_selected.COUNT
     LOOP
        v_in_text := v_in_text || v_selected (i);
  
        IF i &lt; v_selected.COUNT
        THEN
           -- v_in_text := v_in_text || ', ';
           v_in_text := v_in_text || ',';
        END IF;
     END LOOP;
  
     -- v_in_text := '''' || replace(:P1_SHUTTLE, ':', ''',''') || '''';
     :P4_BES_EN := v_in_text;
  END;
  </code></pre>
  
  <p>could anybody help me please?!</p>
  
  <p>now i found the Problem i get the variable example Ap','Fd','Ab  and the Problem is thats the variable miss the ' at the beginning and at the end</p>
  
  <p>could anybody tel me how i could add the missing ' in the variable?</p>