--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:

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

Obviously you havn't tried this...it doesn't work.