I need to write a procedure that calculates the Bill Of Material (BOM) tree in Firebird Server.
And, I tried to check the infinite loops in BOM definiton.
Is there any easy way to achieve this problem?

Is it possible to execute procedures recursively?


CREATE PROCEDURE DOSOMEWORK( CODE AS INTERGER)
AS
/* MAKE SOME THING*/



EXECUTE PROCEDURE DOSOMEWORK(:ANOTHER CODE)
SUSPEND;
END


Any comments will be appreciated.

Regards,


[Non-text portions of this message have been removed]