By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,492 Members | 1,351 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,492 IT Pros & Developers. It's quick & easy.

mySQL 5.0.18 and stored procedures

P: n/a
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
Jan 20 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a

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

Jan 20 '06 #2

P: n/a
"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.
Jan 21 '06 #3

P: n/a
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


Jan 22 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.