dbTalk Databases Forums  

Oracle skip numbers

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc Oracle skip numbers

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Oracle skip numbers in the comp.databases.oracle.misc forum.



Reply
Page 3 of 3 < 1 2 3
 
Thread Tools Display Modes
  #21  
Old   
fitzjarrell@cox.net
 
Posts: n/a

Default Re: Oracle skip numbers - 02-12-2008 , 09:24 AM





On Feb 12, 2:53*am, "vasilis" <vasil... (AT) ics (DOT) forth.gr> wrote:
Quote:
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


Reply With Quote
  #22  
Old   
Galen Boyer
 
Posts: n/a

Default Re: Oracle skip numbers - 02-12-2008 , 08:48 PM





On Tue, 12 Feb 2008, vasilisk (AT) ics (DOT) forth.gr wrote:
Quote:
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


Reply With Quote
  #23  
Old   
Galen Boyer
 
Posts: n/a

Default Re: Oracle skip numbers - 02-12-2008 , 08:48 PM


On Tue, 12 Feb 2008, vasilisk (AT) ics (DOT) forth.gr wrote:
Quote:
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


Reply With Quote
  #24  
Old   
Galen Boyer
 
Posts: n/a

Default Re: Oracle skip numbers - 02-12-2008 , 08:48 PM


On Tue, 12 Feb 2008, vasilisk (AT) ics (DOT) forth.gr wrote:
Quote:
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


Reply With Quote
  #25  
Old   
Galen Boyer
 
Posts: n/a

Default Re: Oracle skip numbers - 02-12-2008 , 08:48 PM


On Tue, 12 Feb 2008, vasilisk (AT) ics (DOT) forth.gr wrote:
Quote:
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


Reply With Quote
  #26  
Old   
William Robertson
 
Posts: n/a

Default Re: Oracle skip numbers - 02-13-2008 , 01:42 AM


On Feb 12, 8:53 am, "vasilis" <vasil... (AT) ics (DOT) forth.gr> wrote:
Quote:
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).

First, I would guess that not many people here use Powerbuilder, so if
this behaviour is linked to some standard feature of the product then
you had better explain exactly what it is. What is the relevance of
Powerbuilder specifically?

As for how to stop "Oracle" from updating primary key columns, it may
be necessary for you to look at the application code and see what it's
doing. Why is it updating the ID column at all, when from what you say
it should not? It is possible that the code contains what we
programmers call a "bug".


Reply With Quote
  #27  
Old   
William Robertson
 
Posts: n/a

Default Re: Oracle skip numbers - 02-13-2008 , 01:42 AM


On Feb 12, 8:53 am, "vasilis" <vasil... (AT) ics (DOT) forth.gr> wrote:
Quote:
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).

First, I would guess that not many people here use Powerbuilder, so if
this behaviour is linked to some standard feature of the product then
you had better explain exactly what it is. What is the relevance of
Powerbuilder specifically?

As for how to stop "Oracle" from updating primary key columns, it may
be necessary for you to look at the application code and see what it's
doing. Why is it updating the ID column at all, when from what you say
it should not? It is possible that the code contains what we
programmers call a "bug".


Reply With Quote
  #28  
Old   
William Robertson
 
Posts: n/a

Default Re: Oracle skip numbers - 02-13-2008 , 01:42 AM


On Feb 12, 8:53 am, "vasilis" <vasil... (AT) ics (DOT) forth.gr> wrote:
Quote:
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).

First, I would guess that not many people here use Powerbuilder, so if
this behaviour is linked to some standard feature of the product then
you had better explain exactly what it is. What is the relevance of
Powerbuilder specifically?

As for how to stop "Oracle" from updating primary key columns, it may
be necessary for you to look at the application code and see what it's
doing. Why is it updating the ID column at all, when from what you say
it should not? It is possible that the code contains what we
programmers call a "bug".


Reply With Quote
  #29  
Old   
William Robertson
 
Posts: n/a

Default Re: Oracle skip numbers - 02-13-2008 , 01:42 AM


On Feb 12, 8:53 am, "vasilis" <vasil... (AT) ics (DOT) forth.gr> wrote:
Quote:
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).

First, I would guess that not many people here use Powerbuilder, so if
this behaviour is linked to some standard feature of the product then
you had better explain exactly what it is. What is the relevance of
Powerbuilder specifically?

As for how to stop "Oracle" from updating primary key columns, it may
be necessary for you to look at the application code and see what it's
doing. Why is it updating the ID column at all, when from what you say
it should not? It is possible that the code contains what we
programmers call a "bug".


Reply With Quote
Reply
Page 3 of 3 < 1 2 3

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top