At 08:57 PM 7/03/2007, you wrote:

> > CREATE PROCEDURE GET_GENERATOR_VALUE
> > (
> > GENERATOR_NAME VARCHAR(31)
> > )
> > RETURNS
> > (
> > GENERATOR_VALUE BIGINT
> > )
> > AS
> > declare variable stmt varchar(60) = '';
>
>A quick note, "60" seems a bit too short, given that:
>select gen_id (,1) from rdb$database
>
>is already 40 characters :-)

So true. Still, hopefully Don can count. :-)

Helen