Subject | Re: Recursive SP |
---|---|
Author | Alexander V.Nevsky |
Post date | 2002-09-17T08:25:17Z |
--- In ib-support@y..., "Valdir Stiebe Junior" <valdir@p...> wrote:
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.
> Hi! We have a SP here that have to be recursive due to an autorelationship.
> This SP sometimes raise an error: Too Many Concurrent Execution ofthe Same
> Request'.limitation?
> 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
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.