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
http://www.rotursoft.sk
http://exekutor.rotursoft.sk