Subject Re: [ib-support] Recursive SP
Author Fabricio Araujo
Answer by Jason Chapman:
Can't, IB detects the 1000 depth and barfs (as I guess you have found out),
thinking you have gone into an infinite loop.
1) How Deep are you likely to need it to go?
2) Does each iteration require new data from tables?
3) What is the nesting for?

Choices are:
1) Tweak FB and rebuild - I would imagine that it is a constant somewhere.
2) Change your algorithm
3) Do it outside FB

Jason Chapman

JAC2 Consultancy

On Mon, 16 Sep 2002 18:35:35 -0300, Valdir Stiebe Junior 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
>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?
> TIA.
>To unsubscribe from this group, send an email to:
>Your use of Yahoo! Groups is subject to

[]s Fabricio
Systems Developer