Re: Sequence numbers jumping

Fenella Tan wrote:
>
> 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.
>
> Fenella

This may be a problem of trys and retrys. Every attempt to create a record will increment the sequence number. However, obviously if no record is created, the sequence number is used!!

One could try using a on-insert trigger. It means that the record is about to be written (the VB frontend has successfully communicated with the database), and therefore the sequence is used only once.

A second possibility is that the VB front-end is creating a record which is then immediately discarded. I would presume that the action to create (commit) a record is done after the user has entered all the required data and the data has been validated.

Mike Krolewski Received on Sat Sep 27 1997 - 00:00:00 CEST