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]

Reply via email to