Page 1 of 1

can't return a result set in the given context

Posted: Thu Nov 11, 2010 4:03 pm
by RussellEngland
I can create a stored procedure but getting an error when I try to call it, any ideas?

'can't return a result set in the given context'

I get the error in phpmyadmin and in php code.

mysql version 5.1.50

php version 5.2.14

Code: Select all

DELIMITER // 
CREATE PROCEDURE russtest 
(IN mylat FLOAT, IN mylong FLOAT) 
BEGIN 
SELECT * FROM jos_users; 
END // 

call russtest(0,0); 

Re: can't return a result set in the given context

Posted: Sun Nov 14, 2010 12:24 pm
by RussellEngland
Tried it locally on LAMP and it works okay, so I'm guessing its an issue with the version of PHP?

Works with

mysql version 5.1.49-1ubuntu8

php version 5.3.3-1ubuntu9.1

Doesn't work with

mysql version 5.1.50

php version 5.2.14