sorry, I think I lost my edge and now rely too much on IBExpert to catch
my mistakes!

Helen Borrie wrote:

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