|
|
Recursive Stored Procedure - Mysql
|
Views : 759
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
|
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 . |
|
By - Selva, On - 2009-11-30 |
|
|
|
