title: Oracle 11g View resultset of table from Stored procedure in Toad
body: <p>I am a novice to Oracle 11g and would like to view the resultset of a table output from a stored procedure. I have created the procedure and executed it. I just want to view the output in the form of a grid like in SQL Server. Please help me out.</p>
  
  <p>This is the declaration of my procedure:</p>
  
  <p><strong>Spec:</strong></p>
  
  <pre><code>TYPE ret_cursor IS REF CURSOR;
  procedure get_data(
  p_start_dt in varchar2, 
  p_end_dt in varchar2, 
  p_results out ret_cursor,
  p_err_no out number,
  p_err_msg out varchar2
  );
  </code></pre>
  
  <p><strong>Body:</strong></p>
  
  <pre><code>PROCEDURE get_data(
        p_start_dt    IN      VARCHAR2, 
        p_end_dt      IN      VARCHAR2, 
        p_results     OUT     ret_cursor,
        p_err_no      OUT     NUMBER,
        p_err_msg     OUT     VARCHAR2
     )
  </code></pre>