Re: Oracle skip numbers

From: Galen Boyer <>
Date: 12 Feb 2008 20:48:01 -0600
Message-ID: <>

On Tue, 12 Feb 2008, 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).

This is really confusing. Can you rewrite your question? My first thought was you need to ask the database to return rownum and use that to iterate, but it isn't clear what you are doing.

Galen Boyer
Received on Tue Feb 12 2008 - 20:48:01 CST

Original text of this message