----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, March 04, 2003 12:13 PM
Subject: RE: [ib-support] stored procs recompilation


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


I do it in ibconsole.
Autocommit DDL is true.

Example:

<script1>

create procedure pr2
returns
(
i integer
)
as
begin
i = 1;
end
;


create procedure pr1
returns
(
i integer
)
as
begin
execute procedure pr2 returning_values i;
end
;

</script1>

now:
execute procedure pr1
result: 1

<script2>
alter procedure pr2
returns
(
i integer
)
as
begin
i = 2;
end
</script2>

now:
execute procedure pr1
result still: 1 (not 2)


rr