Re: How to Call a Stored Procedure from DBD::mysql

[Daniel Nichter]

At the moment, stored procedures do not work with DBD::mysql 3.0002. Support for this is in progress (per http://www.nntp.perl.org/group/perl.dbi.announce/267). The patch by matteo brancaleoni (http://forums.mysql.com/read.php?51,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.