MySQL Forums
Forum List  »  Perl

Re: Perl calling MYSQL 5 stored procedure
Posted by: matteo brancaleoni
Date: July 18, 2005 08:14AM

The usage is pretty simple, just add the param mysql_multi_result=1 in the dsn definition:
for example
my $dsn = "DBI:mysql:$this->{'dbname'}:$this->{'dbhost'};mysql_multi_results=1";

and you're done... now just CALL your stored procedure and fetch rows as usual...

Matteo.

Options: ReplyQuote


Subject
Written By
Posted
Re: Perl calling MYSQL 5 stored procedure
July 18, 2005 08:14AM


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.