can't return a result set in the given context
Posted: Thu Nov 11, 2010 4:03 pm
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
'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);