Sorry, I spoke too soon. I just made a test case of a proc calling a proc, which works, so I must have a different problem.
- Still would like to know if a function will ever be able to issue a SELECT tho. Cheers Mike -----Original Message----- From: Michael Pheasant [mailto:[EMAIL PROTECTED] Sent: Saturday, 3 April 2004 8:57 PM To: [EMAIL PROTECTED] Subject: can't call a stored proc from another stored proc? Hi, 1) Can a stored procedure call another stored procedure? Ie, can you do 'call someproc()' from within a stored procedure? 2) Also, will a function ever be able to issue a SELECT query? I am using mysql-5.0.1-alpha (built froms ource) , winXP & win2k. The mysql daemon crashes without an error message when I try (1) Cheers, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]