Hi,

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

wich one call another one ...
No need

> To drop all SP you need first to drop the calling procedures.

Yes, but also you can alter all procedure without body script first (with no
order) and after that you can drop all withou order.

> To create all SP you need first to create the called procedures.

Yes, but also you can create all procedures without boby scrip first (with
no order) and after that you can alter all with body scripy without order
:-)

Every problem can be solved in many ways ;-)
You chose the best or ...