Subject | Re: [firebird-support] Max recursion for stored procedures |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2003-06-30T10:51:43Z |
Martijn,
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.
forgot the question...
Set
>Does anyone know the max-recursion level of stored proceduresthis bit is completely Bamsemums to work out for yourself. Just write a
>in Firebird?
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