> > >>CREATE PROCEDURE G (GNAME VARCHAR(31), GSTEP INTEGER)
> > >> RETURNS (GVAL BIGINT) AS
> > >>BEGIN
> > >> EXECUTE STATEMENT 'SELECT GEN_ID(' || UPPER(:GNAME) || ', '
> > >
> > > || :GSTEP || ') FROM RDB$DATABASE'
> > >
> > >> INTO :GVAL;
> > >>END
> > >>
> >
> > Sure does it work, just tried it:
>
> My results are in line with the developer said.
>
> http://groups.yahoo.com/group/firebird-support/message/62039?
> threaded=1

I did get it to work, so I guess you can use parameters/variables.