You can:
1) Create all procedures with headers but empty bodies.
2) The use alter procedure to fill in the bodies and create the
dependencies.

Without doing it this way you can never have procedure calling 1 which calls
2 which sometimes calls 1 again.

JAC.


""PlusPoint Sofware SA"" <info@...> wrote in message
news:005a01c2c5e2$7fb82310$010101c2@stationnet...

> In fact, you need to read all the dependencies from all the SP to know

wich one call another one ...

> To drop all SP you need first to drop the calling procedures.
> To create all SP you need first to create the called procedures.
> All those infos are into de DB$ system table.
> I've made a module calculating order to drop and create script in correct

creation order.

> That's all
> Georges