mySQL 5.0.18 and stored procedures

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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?


Re: mySQL 5.0.18 and stored procedures


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


lbutler's Profile:
View this thread:

Re: mySQL 5.0.18 and stored procedures

Quoted text here. Click to load it

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?

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.

Bill K.

Re: mySQL 5.0.18 and stored procedures

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


Marty wrote:
Quoted text here. Click to load it

Site Timeline