Re: [firebird-support] Do I need to "recompile" dependant stored procedure?

[Ann Harrison aharri...@ibphoenix.com [firebird-support]]

On Thu, Mar 24, 2016 at 5:13 PM, 'Wodzu' brucedickin...@wp.pl
[firebird-support]  wrote:

>
>
> I would have to dig in for example o that behavior, maybe it only seemed
> to me that this has occurred.
>

Don't bother digging, but if it happens again, take notes.

Cheers,

Ann

>
>
>
> 
>

RE: [firebird-support] Do I need to "recompile" dependant stored procedure?

['Wodzu' brucedickin...@wp.pl [firebird-support]]

Thank you Ann for clarification.

 

I would have to dig in for example o that behavior, maybe it only seemed to me 
that this has occurred.

 

Best regards.

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Thursday, March 24, 2016 4:34 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Do I need to "recompile" dependant stored 
procedure?

 

  

On Thu, Mar 24, 2016 at 7:24 AM, brucedickin...@wp.pl 
<mailto:brucedickin...@wp.pl>  [firebird-support] 
<firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> > 
wrote:



I have two procedures:

1. PROC_A
2. PROC_B - which is using internally PROC_A.

Now, I've made some changes in PROC_A, do I need to recompile PROC_B as well? 

 

That depends on what you've done to PROC_A.  Obviously, if you've changed its 
parameters,

then yes, you have to change and recompile PROC_B.

 

If so, what is the shortest way of doing it?

 

Again, it depends.  The easiest - brute force - way is to shutdown your server 
... or at least 

all connections to that database.  Compiled procedures are memory resident and 
go away on

database shutdown.  If not, I think ALTER is the only alternative.


I am pretty sure I've noticed some bad behaviour of PROC_B if I've left it 
without recompilation.

 

You shouldn't if there haven't been changes to the parameters of A.  If you do 
notice something,

you should report the symptoms and error messages.

 

Good luck,

 

Ann

Re: [firebird-support] Do I need to "recompile" dependant stored procedure?

[Ann Harrison aharri...@ibphoenix.com [firebird-support]]

On Thu, Mar 24, 2016 at 7:24 AM, brucedickin...@wp.pl [firebird-support] <
firebird-support@yahoogroups.com> wrote:

>
>
> I have two procedures:
>
> 1. PROC_A
> 2. PROC_B - which is using internally PROC_A.
>
> Now, I've made some changes in PROC_A, do I need to recompile PROC_B as
> well?
>

That depends on what you've done to PROC_A.  Obviously, if you've changed
its parameters,
then yes, you have to change and recompile PROC_B.


> If so, what is the shortest way of doing it?
>

Again, it depends.  The easiest - brute force - way is to shutdown your
server ... or at least
all connections to that database.  Compiled procedures are memory resident
and go away on
database shutdown.  If not, I think ALTER is the only alternative.

>
> I am pretty sure I've noticed some bad behaviour of PROC_B if I've left it
> without recompilation.
>

You shouldn't if there haven't been changes to the parameters of A.  If you
do notice something,
you should report the symptoms and error messages.

Good luck,

Ann

[firebird-support] Do I need to "recompile" dependant stored procedure?

[brucedickin...@wp.pl [firebird-support]]

Hello,

I have two procedures:

1. PROC_A
2. PROC_B - which is using internally PROC_A.

Now, I've made some changes in PROC_A, do I need to recompile PROC_B as well? 
If so, what is the shortest way of doing it?

I am pretty sure I've noticed some bad behaviour of PROC_B if I've left it 
without recompilation. But the only way I know is to ALTER it and this is very 
inconvenient due to length of some procedures.

Thanks.