mySQL 5.0.18 and stored procedures

[Marty]

Is there an issue with stored procedure and mySQL v5.0.18 ?

We are programming an application that need stored procedures and
triggers and our programmer can't make them work, is it a know issue or
our programmer missed something?

Regards,
Marty

[lbutler]

Marty,

How are you accessing the database?

Using DBD::mysql seems to have some issues that several people are
trying to find an answer to.

Check in your programming environment for a flag like
CLIENT_MULTI_STATEMENTS. I seems that it needs to be set to allow
stored procedures to return multiple items.

I have not other answers, just still trying to get an answer for
dbd::mysql.

Lloyd
--
lbutler
------------------------------------------------------------------------
lbutler's Profile: http://techiegroups.com/member.php?userid=48
View this thread: http://www.techiegroups.com/showthread.php?t=100067

[Bill Karwin]

"Marty" <xm******@hotmail.com> wrote in message
news:6acAf.135864$OU5.33619@clgrps13...

Is there an issue with stored procedure and mySQL v5.0.18 ?

We are programming an application that need stored procedures and triggers
and our programmer can't make them work, is it a know issue or our
programmer missed something?

I don't know of any issue with stored procedures. I assume they've been
tested pretty thoroughly in My SQL 5.0 beta. Have you searched the MySQL
bug site? http://bugs.mysql.com/

Are you sure you are using MySQL 5.0 for the server?

Perhaps if you give some more details on what specifically he is trying to
do with stored procedures, what is the actual code he is trying to execute,
and what happens that makes you think it is not working? Any error
messages, for example, would be informative.

It's difficult to comment on newsgroup postings such as yours above.

Regards,
Bill K.

[circuit_breaker]

Stored procedures work fine here, on both Linux and Win32. There is
huge forum about Stored Procedures on the mysql.com web site:

http://forums.mysql.com/

Cheers.
Steve.

Marty wrote:

Is there an issue with stored procedure and mySQL v5.0.18 ?

We are programming an application that need stored procedures and
triggers and our programmer can't make them work, is it a know issue or
our programmer missed something?

Regards,
Marty