Hellen Huang wrote:

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

Try

execute procedure B(:retparam) returning_values :retparam;


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further