Recursive Stored Procedure
by Selva[ Edit ] 2009-11-30 17:38:55
In mysql by default you cannot execute recursive stored procedure , because the mysql server variable max_sp_recursion_depth is set to zero.So to execute stored procedure set the value of the variable max_sp_recursion_depth to greater than zero or upto the number of recursions needed for your stored procedure . The maximum value for max_sp_recursion_depth is 255 .
