title: How to see refcursor result/output in Oracle SQL Developer?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/3526798/best-way-tool-to-get-the-results-from-an-oracle-package-procedure">Best way/tool to get the results from an oracle package procedure</a><br>
    <a href="https://stackoverflow.com/questions/3556336/oracle-sql-developer-show-refcursor-results-in-grid">Oracle SQL Developer: Show REFCURSOR Results in Grid?</a>  </p>
  </blockquote>
  
  
  
  <p>I am new to Oracle SQL Developer. I am using Oracle SQL Developer Version 3.0.
  I was trying to test my SP using the following query.</p>
  
  <pre><code>DECLARE
    type output_cursor is ref cursor;
    P_CURSOR output_cursor;
  BEGIN
    P_CURSOR := NULL;
    myPackage.mySPTest (  P_NOTIFICATION_ID =&gt; 1975357,P_CURSOR =&gt; P_CURSOR) ;
  END;
  </code></pre>
  
  <p>When I ran the above query in my Oracle SQL Developer, I am getting a message 'anonymus block completed' and its not showing any result.</p>
  
  <p>Can anyone help me, how to see the result.</p>
  
  <p>.</p>