Re: Sequence numbers jumping

From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/09/29
Message-ID: <01bccce2$3f9a8e20$54110b87@clamagent>#1/1

Sounds like sequence numbers are being requested but then the (I'm assuming you're doing) INSERT gets rolled back (for whatever reason). Once a sequence number is requested by seq.NEXTVAL, it's gone, whether you really use it or not.
- Dan Clamage

Fenella Tan <fenella_at_voicenet.com> wrote in article <342EF476.CB9D9919_at_voicenet.com>...
> We're having problems with our sequence numbers. For some reason, they
> seem to be jumping up by 20 instead of the specified increment by 1.
> Any ideas on what may cause this ? We're using Oracle 7.3 on UNIX with
> a Visual Basic front-end. The jumps happen intermittently. It'll work
> (increment by 1) for a few records, and then it'll suddenly go up by 20
> again. Appreciate any input.
Received on Mon Sep 29 1997 - 00:00:00 CDT