you'll have to disconnect and reconnect to have the update execute correctly
for you trying it. Have you done this?

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

----- 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





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/