title: Retrieve particular column value using procedure in pl/sql
body: <p>am writing procedure in pl/sql.  when i run the procedure am getting error.Here i enclosed the procedure.</p>
  
  <pre><code>code
  
  PROCEDURE get_CDR_rs_phone (CDR_recordset OUT SYS_REFCURSOR)AS 
  BEGIN 
    OPEN CDR_recordset FOR
     SELECT  zkv.CISCOCUIC_TBL.FLD_callingPartyNumber FROM  zkv.CISCOCUIC_TBL; 
  
  END get_CDR_rs_phone;
  /
  
  getting error when i run this proc
  </code></pre>