I have a stored procedure that may call itself when a certain condition is met.
When I run it at the moment I get the following error: "Recursive limit 0 (as set by the max_sp_recursion_depth variable) was exceeded for routine USER_ADD_COMPATIBLE_USER"
How can I modify this to allow "recursive procedures" and what affects might happen as a result ?
Thank you in advance for your help,
Have a look at chapter 19.2.1 in MySQL Reference manual. Click on the variable name ie max_sp_recursion_depth. I can be set in several different places!