if the script component commits - that all you need to do

-----Original Message-----
From: Robert Razniewski [mailto:gustaf@...]
Sent: Tuesday, 4 March 2003 10:03 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] stored procs recompilation


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




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/