Subject Re: [firebird-support] Max recursion for stored procedures
Author Martijn Tonies

> >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

Bamsemums = good.

> selectable stored procedure TEST_DEPTH (<Depth_Level>) which calls
> TEST_DEPTH(<Depth_Level> - 1) until it reaches 0. Then just do a couple of
> FROM rdb$database
> until you get an error.

Arno kinda did this for me already :-) ... 751 iterations worked. (or 750,
or at least - quite a lot).

(sorry, Monday morning, bit lazy - and I didn't think of the SELECTable

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions