Hi, Could we show your procedure to try to help you ? Geoffroy.
-----Message d'origine----- De : Ananda Kumar [mailto:[EMAIL PROTECTED] Envoyé : vendredi 25 mai 2007 17:35 À : MySQL General Objet : error message Hi All, We are using 5.0.40-enterprise-gpl-log version on our production db. If we run a stored proc, we are getting the below error Query OK, 0 rows affected, 1 warning (0.01 sec) ERROR 1308 (42000): LEAVE with no matching label: SWL_return mysql> show warnings; -> // +-------+------+------------------------------------------+ | Level | Code | Message | +-------+------+------------------------------------------+ | Error | 1308 | LEAVE with no matching label: SWL_return | +-------+------+------------------------------------------+ But on our qa with version 5.0.32-enterprise-gpl-log, the proc gets created and exeuctes also. Can you please help here. regards anandkl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]