title: Returning Count of records from sys_refcursor in Oracle
body: <p>Oracle Version : 11.2.0.2</p>
  
  <p>I have a table ABC which has n number of columns , out of which I need COUNT of status, age and type columns individually  to be given as OUT parameters to other application.</p>
  
  <p>My Other application ( web application ) would display these as below:</p>
  
  <p>STATUS              10</p>
  
  <p>AGE                    05</p>
  
  <p>TYPE                   20</p>
  
  <p>where in 10 , 05 , 20 are COUNT of values from table ABC which I need to pass on to the web application.</p>