can't return a result set in the given context

------_=_NextPart_001_01C89374.13E051C4
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 =3D
DBI:mysql:database=3D<dbname>;host=3D<hostname>;port=3D3316;mysql_multi_r=
esult
s=3D1
DBI->connect($dsn, $login, $password,
{PrintError =3D> 1, AutoCommit =3D> 1,
syb_err_handler =3D> \&message_handler } =
)


DBD::mysql version is 3.0007

Any ideas?

Thanks,

Steve


Steve Wechsler | steven.wechsler [at] mtvstaff.com
Sybase/SQL Server/MySQL Database Administrator
212-846-5683

MTV Networks



------_=_NextPart_001_01C89374.13E051C4--