Subject Re: [firebird-support] bugged "alter procedure"
Author Henryk Paluch
On Tue, 9 Sep 2003, Daniel Rail wrote:

> > You need to compile again procedure A too. When A includes B then change
> > in B is not reflected in A (that A still contains copy of old B
> > procedure).
>
> > It seems that Firebird does not call B from A, but that A contains
> > expanded code from B (somehting like macro expansion), but it is pure
> > guess...
>
> Not true. A actually calls procedure B. A only contains the
> information on how to call B and what is its parameters.

Hi!

Agreed. I was confused by another problem (at least on SuperServer
1.0.x) - when B changes then A still calls old version of B (some
extensive caching of A?). Recompilation of A or restart of database will
help.