Claudio Romero schrieb am 29.11.2010 um 10:55 (-0300):

>
> I have a procedure "A", and a procedure B
> procedure A use procedure B,
> but if I change procedure B, I must recompile procedure A (alter
> procedure) for take the changes.
>
> Firebird SS 2.1.4 - 18367.
>
> This is the normal behavior?

On SS, yes.

On CS, no.

The reason, IIRC, is to be found in how memory for procedures is
managed. In SS, the cache for holding procedures (and other things,
too) is pooled for use by all connections. In CS, a static cache is
allocated to each connection.

I remember this was mentioned a couple of times on this list. While not
referring to stored procedures explicitly, this difference is mentioned
for example in the release notes for FB 1.5.6, PDF p.59, explaining the
parameter "DefaultDbCachePages".

--
Michael Ludwig