Usually I make db updates by scripts in form:


alter procedure proc1
as
begin
exit;
end



Now, I have 2 procs, one depends on the other:


alter procedure proc1
as
begin
execute procedure proc2;
end

alter procedure proc2
as
begin
exit;
end


I want to modify the proc2.
Do I have to recompile proc1?
Like this:

alter procedure proc1
as
begin
exit; /* empty procedure - prepared for modif */
end

alter procedure proc2
as
declare variable i integer;
begin
i = 1;
end

alter procedure proc1
as
begin
execute procedure proc2; /* now recompiled */
end


I there a method to recompile the procedure without supplying its full
source code in script?


thx
rr