stored procedures

It does work for simple selects, but try something like this

http://dev.mysql.com/tech-resources/articles/mysql-storedpro c.html

and you don't get any results.

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=20
call procedure

If you just call it (because you already created it the previous time),
it only produces one result set.



Mark.
=20
=20
This e-mail message is for the sole use of the intended recipient(s) and =
may=20
contain confidential and privileged information of Transaction Network =
Services.
Any unauthorized review, use, disclosure or distribution is prohibited. =
If you=20
are not the intended recipient, please contact the sender by reply =
e-mail and=20
destroy all copies of the original message.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

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-storedpro c.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@m .gmane.org

Re: stored procedures

Martin,
thanks for the tip about "mysql_emulated_prepare=3D1" didn't noticed =
that
one.

The example I've written about is here

http://search.cpan.org/~capttofu/DBD-mysql-3.0004_1/lib/DBD/ mysql.pm

Search the page for "An example would be:"


Mark.

On Thu, 2006-05-25 at 10:09 +0100, Martin J. Evans wrote:
> On 25-May-2006 Mark Strong wrote:
> > It does work for simple selects, but try something like this
> >=20
> > http://dev.mysql.com/tech-resources/articles/mysql-storedpro c.html
> >=20
> > and you don't get any results.
>=20
> Agreed, that example does not work by default but if you add
> mysql_emulated_prepare=3D1 to your connect it does work (at least in =
3.0004) e.g.
>=20
> DBI->connect("dbi:mysql:test;mysql_emulated_prepare=3D1", "xxx", =
"yyy")
>=20
> > 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
> >=20
> > drop procedure if exists
> > create procedure=20
> > call procedure
> >=20
> > If you just call it (because you already created it the previous =
time),
> > it only produces one result set.
>=20
> Where exactly is this example?
>=20
> Martin
> --
> Martin J. Evans
> Easysoft Ltd, UK
> http://www.easysoft.com
>=20
>
=20
=20
This e-mail message is for the sole use of the intended recipient(s) and =
may=20
contain confidential and privileged information of Transaction Network =
Services.
Any unauthorized review, use, disclosure or distribution is prohibited. =
If you=20
are not the intended recipient, please contact the sender by reply =
e-mail and=20
destroy all copies of the original message.

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org