Re: Sequence Number

From: Peter Buzanits <peter_at_icb.co.at>
Date: Fri, 21 May 1999 11:16:56 +0200
Message-ID: <37452488.8DA389C9@icb.co.at>

> There is a "gap" in the retrieval of sequence number from a Sequence
> Table created in Oracle8.
>

Seqences do not guarantee to put out consecutive numbers. They only guarantee to put out unique numbers. There can be many reasons for these gaps:

Another trigger/procedure etc. uses the same sequence, there are transactions that have used numbers from this sequence but have been rolled back etc...

If you want to have consecutive numbers, you must make your own table where you manually update the sequence.

Peter
--

DI Peter Buzanits

mailto:peter@icb.co.at       http://peter.icb.co.at

AOL-IM: Buzanits      Keys available on PGP-Servers
---------------------------------------------------

Received on Fri May 21 1999 - 04:16:56 CDT