MySQL Forums
Forum List  »  Stored Procedures

Problem with recursive call of Stored Procedure
Posted by: Phillip Lawes
Date: December 29, 2005 05:18PM

In trying to run recursive call of a stored procedure, I get this error message:
"ERROR 1456 (HY000): Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine pickup_HolidaysCheck"
I am using version 5.0.17, which is supposed to allow recursive calls.
Can anyone tell me how to fix this?

I am using version 5.0.17, on Mac OS X 10.4

Many thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Problem with recursive call of Stored Procedure
2749
December 29, 2005 05:18PM


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.