RE: stored procedures

On 25-May-2006 Mark Strong wrote:
> It does work for simple selects, but try something like this
> 
> http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html
> 
> and you don't get any results.

Agreed, that example does not work by default but if you add
mysql_emulated_prepare=1 to your connect it does work (at least in 3.0004) e.g.

DBI->connect("dbi:mysql:test;mysql_emulated_prepare=1", "xxx", "yyy")

> Also I'm still baffled by the the example in the MySQL-DBD docs, which
> produces four result sets, and works providing you do it in the
> following order
> 
> drop procedure if exists
> create procedure 
> call procedure
> 
> If you just call it (because you already created it the previous time),
> it only produces one result set.

Where exactly is this example?

Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    
http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@xxxxxxxxxxx