Oracle skip numbers

From: vasilis <>
Date: Tue, 12 Feb 2008 10:53:59 +0200
Message-ID: <formr8$1kg9$>


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. Received on Tue Feb 12 2008 - 02:53:59 CST

Original text of this message