garethhall Posted February 17, 2009 Share Posted February 17, 2009 Hi I have just started looking at using stored procedures but I can't seem to get it to work. Can someone tell me why this does not work. In a normal query select * from Pages; I would get the result from the Pages table. So here is what I tried but with no luck. create procedure test() select * from Pages; So I have confirmed that the procedure is created. Then when I go call test() I get a error the error is "can't return a result set in the given context" Please explain to me Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 17, 2009 Share Posted February 17, 2009 Are you trying this from PHP, or from MySQL console? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 17, 2009 Share Posted February 17, 2009 That sounds like the typical CLIENT_MULTI_STATEMENTS flag issue in php. Quote Link to comment Share on other sites More sharing options...
garethhall Posted February 17, 2009 Author Share Posted February 17, 2009 This is error is in the mysql console Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 17, 2009 Share Posted February 17, 2009 I tried similar procedure here and it ran fine. Are you sure query is correct? Which MySQL version you have? Quote Link to comment Share on other sites More sharing options...
garethhall Posted February 17, 2009 Author Share Posted February 17, 2009 mysql 5 Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 17, 2009 Share Posted February 17, 2009 Can't reproduce. Quote Link to comment Share on other sites More sharing options...
garethhall Posted February 17, 2009 Author Share Posted February 17, 2009 Do you mind writing the exact syntax for me? If need be I can do a youtube video showing the error. Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 17, 2009 Share Posted February 17, 2009 CREATE PROCEDURE test() SELECT * FROM t2; CALL test(); Returns expected resultset here Quote Link to comment Share on other sites More sharing options...
garethhall Posted February 17, 2009 Author Share Posted February 17, 2009 Well know I don't know as that is the syntax I used. I am running mysql 5..1.8 Here is a little more information that might be relevant I have tried and reproduced the error in the following apps. Sequel Pro, phpMyAdmin 3.0.1.1. on Mac os x Quote Link to comment Share on other sites More sharing options...
fenway Posted February 18, 2009 Share Posted February 18, 2009 Why not try creating it using the "DELIMITER" way? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.