Problem with Sequences in Oracle 8.0.5

From: Eyvind Elvestrand <Eyvind.Elvestrand_at_hive.no>
Date: Mon, 6 Aug 2001 13:35:31 +0200
Message-ID: <9klvke$61b$1@snipp.uninett.no>

Have an inventory database running on NT4/Oracle 8.0.5.0.0. The GUI is programmed in Delphi 5 / Odac (ODI) For continuous number series I use Oracles's sequence "machinery", like this:
select SEQ_INV_NR.nextval from DUAL

Now the select statement has begun returning higher numbers than expected - typically 20 higher!

Originally the sequence was created like this : CREATE SEQUENCE SEQ_INV_NR
START WITH 214575
INCREMENT BY 1
NOMAXVALUE
NOCYCLE
CACHE 20 I suspected the cache part, dropped the sequence and recreated it without cache - no good.

Has anybody got a clue!

Best regards from Eyvind. Received on Mon Aug 06 2001 - 06:35:31 CDT