title: How do I pass a list of numbers into a stored procedure?
body: <p>So I have the following stored procedure:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE stored_p
  (
   ntype IN NUMBER          ,
   p_ResultSet OUT  TYPES.cursorType
  )
  AS
  BEGIN
  OPEN p_ResultSet FOR
  select * from table where ttype in ntype;
  END stored_p
  </code></pre>
  
  <p>and, I can call it like this:</p>
  
  <pre><code>VARIABLE resultSet  REFCURSOR
  EXEC stored_p(80001, :resultSet);
  PRINT :resultSet
  </code></pre>
  
  <p>but I want to be able to call it like this:</p>
  
  <pre><code>VARIABLE resultSet  REFCURSOR
  EXEC stored_p([80001,80002], :resultSet);
  PRINT :resultSet
  </code></pre>
  
  <p>How should I modify my stored procedure accordingly? I am doing this so that I can display the results in a Crystal Report... (just in case that affects anything).. Thanks!!</p>