Re: SEQUENCE/TRIGGER Problem

From: Philippe <parnaud_at_yahoo.com>
Date: Thu, 4 Feb 1999 19:20:55 +0100
Message-ID: <79coke$b2q$1@concorde.ctp.com>

Create the sequence with the NOCACHE option, by default oracle use a cache of 20 values.

HTH Philippe

Chris Capson wrote in message <79armv$bv$1_at_garnet.nbnet.nb.ca>...
>I am using a sequence In conjunction with a trigger to create an autonumber
>field everything seems be working fine except for every once and a while
>when I insert a record the sequence seems to jump over numbers in the
>sequence.
>
>Example:
>
>The sequence creates 1,2,3,4,5,10,11,12,21.
>
>Does anybody know what Might be causing this??
>
>Thanks
>Chris Capsonlue
>
>
Received on Thu Feb 04 1999 - 12:20:55 CST