Subject Odp: [firebird-support] How to rebuild all store d procedures / triggers

This is not nescessary until you change only body of procedure. If you change params then this is another story ...

Karol Bieniaszewski

----- Reply message -----
Od: "Roland Turcan konf@... [firebird-support]" <>
Do: <>
Temat: [firebird-support] How to rebuild all stored procedures / triggers
Data: śr., lis 5, 2014 16:46


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