|Subject||Re: [firebird-support] Do I need to recompile a stored procedure?|
> Hi. Firebird 2.5.1 here.Vote for it:
> Lets assume that I have two stored procedures, PROC_A, PROC_B.
> PROC_A is using internally a PROC_B. After some time I've changed a body of PROC_B but not the input or output. I've recompiled PROC_B.
> Do I need to also recompile a PROC_A?
> Many times I've observed a behaviour that if I not also recompile a PROC_A then it will be giving me wrong results (as it would still use the old code of PROC_B). However, I haven't close all connections to the database and maybe this is the reason?
> I also want to ask if there is a simple way of recompiling a procedure? Something like for example:
> RECOMPILE PROCEDURE PROC_A