Subject Re: [firebird-support] allnested sp
Author Lucas Franzen

Marcelo schrieb:
> Hi all!
> When I include a call to a procedure inside an sp, but then modify the
> called procedure, it happens that the calling procedure keeps the old
> version of the called procedure. I have to recompile the calling
> procedure to get things right.

No, you haven't.
But if the procedure that calls another procedure was already in use
(cached) while you are changing the called procedure it will continue
using the cached version until you disconnect / reconnect.

Look that you have single user access when changing metadata and take
care that you reconnect afterwards.

>Isn't it annoying ? Is it bad practice to call an sp from another sp?

No not bad practice. Just common one.