title: fetching results from oracle SP [cursor]
body: <p>I am trying to fetch results from an oracle SP which is returning cursors. 
  I have the following code which does not seem to work...</p>
  
  <pre><code>declare VARIABLE csr1 REFCURSOR;
  declare VARIABLE csr2 REFCURSOR;
  declare VARIABLE csr3 REFCURSOR;
  declare VARIABLE csr4 REFCURSOR;
  declare VARIABLE csr5 REFCURSOR;
  EXEC getReportData('PUB',:csr1,:csr2,:csr3,:csr4,:csr5); 
  PRINT csr1;
  </code></pre>
  
  <p>I looked around SO for this type of question and <a href="https://stackoverflow.com/questions/817472/how-do-oracle-stored-procedures-w-cursors-work/817962#817962">that</a> is there I got the above code.</p>
  
  <p>In that same answer there is a second option to loop as well. but that will not work for me since one of the lines in that code says:</p>
  
  <pre><code>rej_rec Reasons_for_Rejection%ROWTYPE;
  </code></pre>
  
  <p><code>Reasons_for_Rejection</code> is supposedly the table name...however in my SP they are using some internal table because query is like this:</p>
  
  <pre><code>select c.blah from (select blah1 from blah) c
  </code></pre>