Re: Oracle skip numbers

From: <>
Date: Tue, 12 Feb 2008 07:24:11 -0800 (PST)
Message-ID: <>

On Feb 12, 2:53 am, "vasilis" <> wrote:
> Hello,
> When using Powerbuilder with Oracle, in some cases oracle skips numbers.
> What I mean is that when the ID column has a value of 100, instead of
> getting the next value(101) I get 102 or 103 anything but not the next. It
> updates the same row from 100 to 103 and of course as you might imagine I
> can not retrieve the row of 100. How this problem may be solved(Not updating
> the id column to a different value).
> Thanks in advance.

Normally a sequence is used to generate a surrogate key value, so I'm wondering why you're updating an apparent key?

You'll need to explain this MUCH better than you have to get a valid, usable response.

David Fitzjarrell Received on Tue Feb 12 2008 - 09:24:11 CST

Original text of this message