I am having a hard time running some stored procedures from a Perl script. I had everything working on my internal server, but when I moved it to DreamHost, nothing works. I know that the database settings are correct.
I can create the stored procedures, but they will not execute from phpMyAdmin or from my Perl script. When I run the Perl script, I get an error from the Perl script that the stored procedure failed. I can run the stored procedure from MySQL Query Browser (connected to the database) and it works.
For example, I created the following stored procedure:
SELECT ‘it works!’;
When I try and run it from phpMyAdmin, it produces the following error:
#1312 - PROCEDURE agps.myproc can’t return a result set in the given context
(agps is the database name)
Does DreamHost even support stored procedures?
Any help will be appreciated.