title: Executing a stored procedure in Oracle SQL Developer
body: <p>I am looking for some help in getting the following stored proc to work: I get anonymous block completed and not able to see the result. It works perfectly fine in PL/SQL devloper's "tes" window, but I would like to see it work in the ORACLE SQL Developer</p>
  
  <hr>
  
  <pre><code>DECLARE  
  TYPE OUTPUT_CURSOR IS REF CURSOR  
  t_c OUTPUT_CURSOR  
  BEGIN  
  P_M.E_S.T_S_QUERY( 123,'ABC','20100101','20100131','ALL',:t_c);    
  END;  
  </code></pre>