| Subject | Re: [firebird-support] Re: Generators and Stored Procedures |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2005-06-17T10:34:18Z |
CREATE PROCEDURE G (GNAME VARCHAR(31), GSTEP INTEGER)
RETURNS (GVAL BIGINT) AS
BEGIN
EXECUTE STATEMENT 'SELECT GEN_ID(' || UPPER(:GNAME) || ', ' || :GSTEP || ') FROM RDB$DATABASE'
INTO :GVAL;
END
Ivan
RETURNS (GVAL BIGINT) AS
BEGIN
EXECUTE STATEMENT 'SELECT GEN_ID(' || UPPER(:GNAME) || ', ' || :GSTEP || ') FROM RDB$DATABASE'
INTO :GVAL;
END
Ivan