Subject Do I need to "recompile" dependant stored procedure?
Author
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.