title: How to enter binds for a multi-valued parameter in SQL Developer
body: <p>I have a lot of SQL with named parameters that I need to be able to execute in SQL Developer. For SQL where the parameters are scalar values it's easy to paste the SQL into a worksheet and SQL Developer will prompt me (in a dialog with the title "Enter Binds") to enter the parameter values. But for cases where the parameter needs to hold multiple values, like this:</p>
  
  <pre><code>select count(*) from foo 
  where foo.id in (:ids)
  </code></pre>
  
  <p>where, say, <code>:ids</code> needs to be replaced with <code>1,2,3</code> so that the query executed is</p>
  
  <pre><code>select count(*) from foo 
  where foo.id in (1,2,3)
  </code></pre>
  
  <p>I try entering the values into the dialog (and I've tried delimiting with commas, or just spaces, or wrapping everything in parens), and regardless what I try I get the error message:</p>
  
  <pre><code>ORA-01722: invalid number
  01722. 00000 -  "invalid number"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>Is there a syntax for entering the multiple values into the "Enter Binds" dialog so that SQL Developer will be able to perform the substitution correctly? Or are the bindings strictly limited to scalar values?</p>
  
  <p>I'm using Oracle SQL Developer 3.2.20.09.</p>