I am using Version 3.2.4 of phpMyAdmin and have, apparently, been successful in creating a stored procedure which I called "get_stuff". Now I'm trying to figure out how to CALL it from within the SQL window.
So I tried to follow it with:
CALL practice2.get_stuff(12);
However I get the result:
#1312 - PROCEDURE practice2.get_stuff can't return a result set in the given context
any thoughts on this?
thanks,
chop
phpMyAdmin
Moderator: General Moderators
Re: phpMyAdmin
The internet is your friend: http://stackoverflow.com/questions/2842 ... -procedure
Re: phpMyAdmin
I am using MAMP Version 3.2.4 of phpMyAdmin. Still can't get the CALL to work
chop
chop
Re: phpMyAdmin
If the mysql server is on your computer try using the command line mysql to test your procedure. That will eliminate large chunks of potential problem-causing software like a phpmyadmin issue or something.
Re: phpMyAdmin
Did you check your mysql permissions to make sure you can run stored procedures for localhost and your server?