title: mysql #1312 - PROCEDURE can't return a result set
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2466713/use-result-set-of-mysql-stored-procedure-in-another-stored-procedure">use result set of mysql stored procedure in another stored procedure</a>  </p>
  </blockquote>
  
  
  
  <p>Executing Mysql stored procedure in phpMyadmin getting error </p>
  
  <p>my stored procedure</p>
  
  <pre><code>DROP PROCEDURE `SP_GetNews`//
  CREATE DEFINER=`user`@`%` PROCEDURE `SP_GetNews`()
  BEGIN
  
  (Select * from tbl_news where Nw_Dontshowstatus = 0) order by Nw_UploadedTime desc;
  
  END
  </code></pre>
  
  <p>when calling the SP</p>
  
  <pre><code>CALL SP_GetNews;
  </code></pre>
  
  <p>will giving the error:</p>
  
  <blockquote>
    <p>mysql #1312 - PROCEDURE  can't return a result set in the given context</p>
  </blockquote>
  
  <p>Any solution?</p>