MySQL Forums
Forum List  »  Perl

Re: Perl calling MYSQL 5 stored procedure
Posted by: matteo brancaleoni
Date: June 17, 2005 07:16AM

Hi.

You can use stored procedures if you do SELECT INTO and the SELECT the var.
DBD::MYSQL doesn't support multiple rows statements like a simple select
in a stored procedures...
But I've sent a patch to perl DBD::MySQL mantainer for supporting that,
(is only a issue to enable certain flags on mysql connection) that you can find
from http://rt.cpan.org/NoAuth/Bug.html?id=12322 .
The patch has not been added to DBD::MySQL, but works like a charm
(I'm using it on some production machines).

Enjoy.

Options: ReplyQuote


Subject
Written By
Posted
Re: Perl calling MYSQL 5 stored procedure
June 17, 2005 07:16AM


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.