title: PL/SQL query IN comma deliminated string
body: <p>I am developing an application in Oracle APEX. I have a string with user id's that is comma deliminated which looks like this,</p>
  
  <pre><code>45,4932,20,19
  </code></pre>
  
  <p>This string is stored as </p>
  
  <pre><code>:P5_USER_ID_LIST
  </code></pre>
  
  <p>I want a query that will find all users that are within this list my query looks like this</p>
  
  <pre><code>SELECT * FROM users u WHERE u.user_id IN (:P5_USER_ID_LIST);
  </code></pre>
  
  <p>I keep getting an Oracle error: Invalid number. If I however hard code the string into the query it works. Like this:</p>
  
  <pre><code>SELECT * FROM users u WHERE u.user_id IN (45,4932,20,19);
  </code></pre>
  
  <p>Anyone know why this might be an issue?</p>