Increasing Stored Procedure "Recursive Limit"

Databases
1

Greetings,

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,

Mr. Alexander

2

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!