Subject | Re: [firebird-support] Re: Generators and Stored Procedures |
---|---|
Author | Ivan Prenosil |
Post date | 2005-06-17T10:26:12Z |
You can't pass parameters that way.
Just do it as I show you in previous email.
Ivan
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.