title: PL/SQL - comma separated list within IN CLAUSE
body: <p>I am having trouble getting a block of pl/sql code to work. In the top of my procedure I get some data from my oracle apex application on what checkboxes are checked. Because the report that contains the checkboxes is generated dynamically I have to loop through the </p>
  
  <pre><code>APEX_APPLICATION.G_F01 
  </code></pre>
  
  <p>list and generate a comma separated string which looks like this</p>
  
  <pre><code>v_list VARCHAR2(255) := (1,3,5,9,10);
  </code></pre>
  
  <p>I want to then query on that list later and place the v_list on an IN clause like so</p>
  
  <pre><code>SELECT * FROM users 
  WHERE user_id IN (v_list);
  </code></pre>
  
  <p>This of course throws an error. My question is what can I convert the v_list to in order to be able to insert it into a IN clause in a query within a pl/sql procedure?</p>