title: Get resultset from oracle stored procedure
body: <p>I'm working on converting a stored procedure from SQL server  to Oracle. 
  This stored procedure provides a direct resultset. I mean that if you call the stored procedure in eg Management Studio you directly obtain the resultset. </p>
  
  <p>By converting to Oracle I walk against the problem that I in Oracle will not display the resultset</p>
  
  <p>I searched on the Internet and have seen that the stored procedure should yield a REF CURSOR, but I still walk with the problem to write a little piece of code to obtain the resultset en process that.</p>
  
  <p>Pseudo Code: </p>
  
  <p>Call stored procedure and obtain cursor
  Do something with that cursor so that my resultset appears</p>
  
  <p>Someone an idea?</p>