Subject Re: Generators and Stored Procedures
Author Adam
I do not believe you can use parameters for the generator names like
this. You could try as a work around:


declare variable stmt varchar(200);
begin
stmt = 'select gen_id(' || :gen_name || ', ' || :gen_increment || ')
from RDB$DATABASE';

EXECUTE STATEMENT stmt INTO :gen_value;

....
end
^