| Subject | Re: Generators and Stored Procedures | 
|---|---|
| Author | Adam | 
| Post date | 2005-06-17T07:02:30Z | 
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
^
            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
^