--- In firebird-support@yahoogroups.com, Milan Babuskov <albis@e...>
wrote:

> Unless you tell us what exaclty did you do

step 1:

create procedure test
returns
(result integer)
as
begin
result=1;
suspend;
end

step 2:

create procedure test1
returns
(result integer)
as
begin
select result from test into :result;
suspend;
end

step 3:

(try procedure test1)

select result from test1

Result=1 (as expected)

step 4:

alter procedure test
returns
(result integer)
as
begin
result=2;
suspend;
end

step 5:

(try procedure test1)

select result from test1

Result=1 (instead of the expected value 2)

Isn't this a bug ?

Peppe Polpo