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

Sure does it work, just tried it:

------ Performance info ------
Prepare time = 0ms
Execute time = 0ms
Current memory = 959.024
Max memory = 1.091.776
Memory buffers = 2.048
Reads from disk to cache = 0
Writes from cache to disk = 0
Fetches from cache = 10

Prozedur Resultat:

GVAL = 5