Problem with recursive call of Stored Procedure
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.
Subject
Views
Written By
Posted
Problem with recursive call of Stored Procedure
2749
December 29, 2005 05:18PM
1554
December 29, 2005 05:58PM
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.