Subject Re: [firebird-support] Re: Generators and Stored Procedures
Author Ivan Prenosil
You can't pass parameters that way.
Just do it as I show you in previous email.

Ivan


> That's fine, but how come it still doesn't work when you use a
> variable for the incrementor?
>
> ex.
>
> DECLARE VARIABLE gen_increment INTEGER;
> DECLARE VARIABLE GVAL BIGINT;
>
> gen_increment = 2;
>
> EXECUTE STATEMENT 'SELECT GEN_ID(MYGEN, :gen_increment) FROM
> RDB$DATABASE' INTO :GVAL;
>
>
> Error:
> Dynamic SQL Error.
> SQL error code = -206.
> Column unknown.
> GEN_INCREMENT.