>> 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
>>
>
> Obviously you havn't tried this...it doesn't work.

Did you get error message (which one?) or wrong result ?

Ivan