Subject | Do I need to "recompile" dependant stored procedure? |
---|---|
Author | |
Post date | 2016-03-24T11:24:49Z |
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.
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.