Re: Order of sequence number generation

From: Tomm Carr <tommcatt_at_ix.netcom.com>
Date: 1997/10/24
Message-ID: <345180C7.B32B30FF@ix.netcom.com>#1/1

Sabarinath Nair wrote:

> Hello,
>
> I have a sequence created using the foolowing SQL.
>
> create sequence SEQ_MESSAGE_ID INCREMENT BY 1 START WITH 100 maxvalue
> 999999999999 ORDER;
>
> When I use this sequence, thru a stored procedure, the sequence numbers
> which are generated are not incrimented by 1. instead it gets increments
> of 20. 1, 21, 42 etc...
>
> Does any one know how to get around this...
>

Creating the sequence with NOCACHE should do it.

Tomm Received on Fri Oct 24 1997 - 00:00:00 CDT