can"t return a result set in the given context

can"t return a result set in the given context

am 31.03.2008 23:13:33 von steven.wechsler

------_=_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 can't return a
result set in the given context at /dba/steve/scripts/run_sql.pl line
517, line 2.

Here is the connect string:

$dsn =3D
DBI:mysql:database=3D;host=3D;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@mtvstaff.com
Sybase/SQL Server/MySQL Database Administrator
212-846-5683

MTV Networks



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