Re: Order of sequence number generation

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...
>
> Thanks
> Sabari

Dear Sabarinath,

this may be due to sequence number caching. Try the NOCACHE parameter.

Regards, Christian. Received on Fri Oct 24 1997 - 00:00:00 CDT