Set,

> >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
>
> SELECT TEST_DEPTH(TestValue)
> 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
procedure)



With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com