title: How to loop through a delimited list in Oracle PLSQL
body: <p>I am working on an Oracle procedure that calls another procedure within it. One of my parameters <code>(parm1)</code> can contain one or more values in a comma separated list. How can I loop through these values to pass them one at a time to another procedure?</p>
  
  <p>Here is an example of what I would like it to do:</p>
  
  <pre><code>When Parm1 = 123,312
  
  callProcedure2(123)
  callProcedure2(321)
  </code></pre>
  
  <p>-or-</p>
  
  <pre><code>When Parm1 123
  
  callProcedure2(123)
  </code></pre>
  
  <p>I think this can be accomplished using a loop but I can't figure out how to get it to use each value as a separated call within the loop.</p>
  
  <p>Any help would be appreciated!</p>
  
  <p>Thanks!</p>