I can execute the following query from inside the mysql command client client and it works successfully, but when it is called through a JDBC CallableStatement, it fails telling me that the max_sp_recursion_depth is 0. The max_sp_recursion_depth is set to 10 on the server. Is there ...
Bug #21110limit of max_sp_recursion_depth Submitted:18 Jul 2006 10:46Modified:18 Jul 2006 16:46 Reporter:Nikolay ShestakovEmail Updates: Status:VerifiedImpact on me: None Category:MySQL Server: Stored RoutinesSeverity:S4 (Feature request) ...
Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine myproc. I have changed max_sp_recursion_depth=255 but myproc still not work. Please help me. Thanks Subject Views Written By Posted Recursive limit 0 (as set by the max_sp_recursion_depth variable...
call myproc(a); end if; END; when i call myproc(0) , it show error : Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine myproc. I have changed max_sp_recursion_depth=255 but myproc still not work. Please help me. ThanksNavigate...
Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine myproc. I have changed max_sp_recursion_depth=255 but myproc still not work. Please help me. Thanks Subject Views Written By Posted Recursive limit 0 (as set by the max_sp_recursion_depth variable...
MySQL Forums Forum List » Stored Procedures Advanced Search New Topic Re: Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine myprocPosted by: Devart Team Date: January 18, 2011 06:50AM You could use WHILE statement instead of using recursive ...