can't return a result set in the given context

"Wechsler, Steven" <[email protected]> Mon, 31 Mar 2008 17:13:33 -0400

Newsgroups	gmane.comp.db.mysql.perl
Message-ID	<9BFA664319211B4780C5F8A4FB060FF50121A3CF@LAZYTOWN.mtvn.ad.viacom.com>

I get the above error whenever I try to call a stored procedure using
DBI with DBD::MySQL. The exact message is:

DBD::mysql::st execute failed: PROCEDURE <procname> can't return a
result set in the given context at /dba/steve/scripts/run_sql.pl line
517, <FILE> line 2.

Here is the connect string:

$dsn =
DBI:mysql:database=<dbname>;host=<hostname>;port=3316;mysql_multi_result
s=1
DBI->connect($dsn, $login, $password,
                               {PrintError => 1, AutoCommit => 1,
                                syb_err_handler => \&message_handler } )


DBD::mysql version is 3.0007

Any ideas?

Thanks,

Steve


Steve Wechsler | [email protected]
Sybase/SQL Server/MySQL Database Administrator
212-846-5683

MTV Networks