Hi All,

I want to make a stored procedure which return values, so I can use the returned value as input parameter for other procedure.
I've already tried this one,

set term ^;
create procedure A
(param1 char(8))
returns(retparam1 numeric(5))
as
begin
if (param1='GOOD' ) then
retparam = 100;
else
retparam = 0;

execute procedure B(:retparam);
end ^
set term ;^

but when I executed it, it was return null values...

Can anyone tell me how to make the right one..?

Regards'

Hellen


[Non-text portions of this message have been removed]