MySQL Forums
Forum List  »  Perl

Re: How to Call a Stored Procedure from DBD::mysql
Posted by: Daniel Nichter
Date: January 12, 2006 07:39PM

At the moment, stored procedures do not work with DBD::mysql 3.0002. Support for this is in progress (per The patch by matteo brancaleoni (,30177,30256#msg-30256) enables multi-result support when the DBD::mysql client connects to the MySQL server (during the initial handshake), but DBD::mysql does not actually (or correctly) handle multi-results. That is because there's a difference in protocol between normal (single) results and multi-results which DBD::mysql doesn't understand. Basically, multi-results have extra packets to delineate the result sets; these extra packets often confuse DBD::mysql. -- It's not possible to call a stored procedure without using multi-results, even if the SP only returns one result.

Options: ReplyQuote

Written By
Re: How to Call a Stored Procedure from DBD::mysql
January 12, 2006 07:39PM

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.