1

Possible Duplicate:
use result set of mysql stored procedure in another stored procedure

Executing Mysql stored procedure in phpMyadmin getting error

my stored procedure

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

when calling the SP

CALL SP_GetNews;

will giving the error:

mysql #1312 - PROCEDURE can't return a result set in the given context

Any solution?

Community
  • 1
  • 1
Ranipriya
  • 29
  • 3

0 Answers0