Recursive stored procedures

[Ruslan Zasukhin]

On 1/21/09 8:42 PM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:

Hi Bart,

> Hi List, Ruslan
> 
> short question:
> can SP's call themselves recursively ?

It seems yes.

But be careful,

    if you will not make right RETURN branches
    you will get endless loop

    also issue with deep of recursion.
    I think it can be until eat the whole RAM :)


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]