Subject Re: Recompiling of dependent procedures
Author Adam
--- In firebird-support@yahoogroups.com, Roland Turcan <konf@...> wrote:
>
> Hello FireBird Support!
>
> Do I need to recompile dependent procedures when referred one has been
> changed?

It depends what you change. If you change the body, then no. If you
change the declaration of the inner procedure, then yes.

> If do so, then what is the best way (only ALTER PROCEDURE statement)?
>

Yes. I personally redeclare the entire thing, I don't know if setting
it inactive then active would achieve the same.

Adam