Subject Re: [firebird-support] parameter mismatch for procedure
Author Helen Borrie
At 08:45 AM 19/01/2007, Steve Wiser wrote:
>Your stored procedure has no input parameters, just 1 return parameter.
>The correct way to call this procedure is:
>
>execute procedure P_BROKER_ID
> returning_values( N );

EXECUTE PROCEDURE is a DSQL call, so the reference to the variable
requires a colon prefix:

execute procedure P_BROKER_ID
returning_values( :N );

./hb