Sequence

From: Rook <blackrook_at_darkhorsefan.net>
Date: Sun, 19 Mar 2000 06:42:06 GMT
Message-ID: <sd8tlbgelul168_at_corp.supernews.com>

[Quoted] [Quoted] I am working with Personal Oracle 8 on a win95 platform. My problem is, I have a simple sequence which is part of a procedure.

create sequence addid_sequence
begin with 1
increment by 1;

When I execute the procedure, the first id value is 2. The next to id values increment by 2 and finally, the last two executions result in values that increment by 4. Any ideas on what causes this and how can I fix this problem?

Thank you in advance. Received on Sun Mar 19 2000 - 07:42:06 CET