MySQL Forums
Forum List  »  Perl

Re: Perl calling MYSQL 5 stored procedure
Posted by: Paul Lucassen
Date: November 30, 2005 01:58AM

Hi,

for those that supposed that the patch is already in the current (3.02) release of DBD::mysql, this is what I got (SLES9,Mysql5.0.16,DBD::mysql 3.02):

DBD::mysql::db do failed: PROCEDURE <proc_name> can't return a result set in the given context

which was resolved after patching with the aforementioned patch by matteo brancalenoni,
and turning it on by issuing 'mysql_multi_results=1' with:
my $db = DBI->connect("DBI:mysql:database=$schema;host=$dbhost;mysql_multi_results=1",$dbuser,$dbpass);

cheers, and thanks for the patch,
Paul

Options: ReplyQuote


Subject
Written By
Posted
Re: Perl calling MYSQL 5 stored procedure
November 30, 2005 01:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.