Hello all,

I have two procedures:

ProcA  and  ProcB where ProcB calls ProcA. I have made the altering of
ProcA  because  of  bugfix and I haven't touched the ProcB, because it
was OK.
When  I  was getting the results from ProcB, it still haven't returned
me  as  I  wanted  and then I've got the results from ProcA for test I
saw,  that  ProcA  returns correct values and ProcB still return wrong
values based on old version of ProcA.

Therefore  I  think  I have to call "alter procedure ProcB" as well to
get ProcB working with actual version of ProcA.

OK,  this  is  a very simple example, but the relations are much wider
and deeper.

How   can   I   force  Firebird  to  rebuild  all  procedures  without
backup/restore?

Do you have any trick how to easily rebuild them?

-- 
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk

Reply via email to