Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Auto Generated Sequence Skipping Numbers

417429Aug 30 2004 — edited Sep 9 2004
I am creating an application with which internal customers can make requests. I have a confirmation page which displays to the user a confirmation number from an auto-generated sequence in a column from the table the data is input to. When I'm testing it, and I enter consecutive requests with the application one after the other, it works fine; however, once I leave it and come back to enter another one, the confirmation number the entry is assigned from the auto-generated sequence of numbers skips ahead about 20 numbers. This is not a major issue, as the numbers will still technically remain numerically sequential and distinct, but I'd like to fix this if possible.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2004
Added on Aug 30 2004
5 comments
949 views