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
^