Subject Re: [firebird-support] Max recursion for stored procedures
Author Svein Erling Tysvaer
Martijn,

>Does anyone know the max-recursion level of stored procedures
>in Firebird?

this bit is completely Bamsemums to work out for yourself. Just write a
selectable stored procedure TEST_DEPTH (<Depth_Level>) which calls
TEST_DEPTH(<Depth_Level> - 1) until it reaches 0. Then just do a couple of

SELECT TEST_DEPTH(TestValue)
FROM rdb$database

until you get an error.

>And is this max defined on a per "branch" call-stack?

Jeg vet ikke/jag vet värkligen inte/ne znajo/ich weisse nicht/que?/Sorry, I
forgot the question...

Set