Problem with Oracle sequence

[GaryNY]

I defined an Oracle sequence, which is used in my application to generate
unique increasing numbers.
I set it from 1 with increment also 1, expecting it to grow by 1.
The definition in USER_SEQUENCES table is correct.

When I test this sequence in SQL*Plus session it returns expected values in
CURRVAL and NEXTVAL functions.

To contrary, my CF application, which uses this sequence in it's SQL (via
NEXTVAL), gets new numbers in different unpredictable fashion. Sometimes
several hundred greater then the previous number.

Does anybody met this before ?
What could be the problem ?

[frankjshin]

Did you use something like the following to set up the sequence?

CREATE SEQUENCE seq_name
MINVALUE 1
MAXVALUE 100000
START WITH 1
INCREMENT BY 1
CACHE 20;


Then to insert the autonumber in a query:

<cfquery name="test" datasource="#ds1#">
INSERT INTO test_table
(test_id, test_name)
VALUES
(seq_name.nextval, 'Test123');

That works for me just fine.

Frank
</cfquery>

[GaryNY]

Something like that, I also extracted NEXTVAL for constructing unique names (in combination with other chars).
But it is incremented in gaps...

[frankjshin]

Can you put in the actual code you used in SQL PLUS to create the sequence and the query?

[GaryNY]

It was the standard code, increment was set to 1, NOMAX, NOCYCLE.