Page 1 of 1

phpMyAdmin

Posted: Mon May 30, 2011 10:56 am
by chopWood
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

Re: phpMyAdmin

Posted: Thu Jun 02, 2011 10:15 am
by Jade

Re: phpMyAdmin

Posted: Thu Jun 02, 2011 7:31 pm
by chopWood
I am using MAMP Version 3.2.4 of phpMyAdmin. Still can't get the CALL to work
chop

Re: phpMyAdmin

Posted: Thu Jun 02, 2011 11:42 pm
by Doug G
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

Posted: Tue Jun 07, 2011 9:14 am
by Jade
Did you check your mysql permissions to make sure you can run stored procedures for localhost and your server?