MySQL Forums
Forum List  »  Stored Procedures

Re: Error 1456. Recursive limit 0 was exceeded for routine
Posted by: Luis Sieira
Date: May 17, 2012 04:52AM

Whenever you define a recursive stored procedure you have to adapt max_sp_recursion_depth to your needs.

DELIMITER $$

SET @@SESSION.max_sp_recursion_depth=25; $$
CREATE PROCEDURE `your_incredibly_amazing_procedure`(...)
BEGIN
...
END; $$

This system variable (by default setted to 0) avoids infinite recursion (which mysql just don't know how to handle)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error 1456. Recursive limit 0 was exceeded for routine
14569
May 17, 2012 04:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.