Order of sequence number generation

Hello,

[Quoted] [Quoted] I have a sequence created using the foolowing SQL.

[Quoted] [Quoted] create sequence SEQ_MESSAGE_ID INCREMENT BY 1 START WITH 100 maxvalue 999999999999 ORDER; [Quoted] 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...

[Quoted] Does any one know how to get around this...

Thanks
Sabari Received on Wed Oct 22 1997 - 00:00:00 CEST