Subject Re: Recursive SP
Author Alexander V.Nevsky
--- In ib-support@y..., "Valdir Stiebe Junior" <valdir@p...> wrote:
> Hi! We have a SP here that have to be recursive due to an auto
relationship.
> This SP sometimes raise an error: Too Many Concurrent Execution of
the Same
> Request'.
> I'm sure that this SP will not get in an endless loop.
> So, how can i solve this?
> How firebird detect this 'recursive sp' and how to change this
limitation?

Valdir, depth of recursion is limited by 1000, if your procedure
does'nt exhaust some OS resource (stack for example) earlier.

Best regards, Alexander V.Nevsky.