Sequence problem

From: Fred Hurtubise <fhurtubi_at_videotron.net>
Date: 1997/11/06
Message-ID: <346204DA.6887@videotron.net>#1/1

Hi,

I have a bizarre sequence problem...sometimes, the sequence increment by 1, wich is what I want, but sometimes, the sequence increment by 20, 19, 15, or else...I mostly saw jumps of 19 and 20...

And what's more bizarre, it's that most of the time, jumps occurs during the 1st entry of the day...

The sequence is used with a trigger when I insert in a table (before insert)

The sequence is used to specify unique Id's, and having declared that field to be 10 numbers long, I'm worrying about reaching the limit before that it should!

Please reply via email...

Frederic Hurtubise
fhurtubi_at_videotron.net
W3 & Oracle Programmer
http://www.infinit.net Received on Thu Nov 06 1997 - 00:00:00 CST