SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast Mr.Alexander's Avatar
    Join Date
    Apr 2010
    Location
    Toronto, Canada
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Increasing Stored Procedure "Recursive Limit"

    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. #2
    SitePoint Member
    Join Date
    Apr 2010
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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!


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •