RE: stored procedures
"Martin J. Evans" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Organization | Easysoft Ltd |
| Message-ID | <[email protected]> |
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/[email protected]