title: Oracle 11g - sys_refcursor
body: <p>I am working on a system where Oracle 11g is the back end database.
  I have very limited permissions on the database and as such all I can do is call procedures that reside in packages.</p>
  
  <p>Gerally, these procedure return their result set via an OUT parameter of type sys_refcursor.</p>
  
  <p>I can call them fine in C# and get data from the cursor via the C# OracleDataset type.</p>
  
  <p>Here is my question.
  I want to be able to run these procedures and see the results via SQL Developer.
  I can execute the procedure fine, but seeing the contents of the sys_refcursor OUT parameter is boggling me.</p>
  
  <p>I've done some gooling and people ar saying about creating type and other solutions I simply do not have the permissions to persue.</p>
  
  <p>So, how can I possibly see the result set contained in a sys_refcursor?
  So say I have a procedure with this signature....</p>
  
  <pre><code>procedure an_oracle_Proc(p_ref         IN  varchar2,
                           p_result_set  OUT sys_refcursor);
  </code></pre>
  
  <p>I call it like this....</p>
  
  <pre><code>DECLARE
    l_ref VARCHAR2(10);
    l_result_set sys_refcursor;
  BEGIN
    oracle_pkg.an_oracle_Proc(p_ref =&gt; l_ref,
                                            p_result_set =&gt; l_result_set);
  
    --How to select from l_result_set with limited permissions
  END     
  </code></pre>
  
  <p>How can I look at the contents of l_result_Set?</p>