Subject How to rebuild all stored procedures / triggers
Author Roland Turcan
Hello guys,

How can I rebuild all my SP or triggers after altering of one which
has many depended callings.

How can I assure that my altered SP will be used in all objects
depending on it instead of old BLR of it.

Should I call "alter procedure" and "alter trigger" on all SP or TR.
If yes, then what about order to execute them? Does the order matter?

Thanks for all responses in advance.

Best regards, TRoland