NextVal quirk

From: Patrick Janidlo <janidlo_at_visionarysoftware.spamthis.com>
Date: Fri, 18 Sep 1998 17:51:53 -0500
Message-ID: <3AAM1.1111$AT4.5843016@proxye1.nycap.rr.com>

On WindowsNT 4.0 Server service pack 3, Oracle 8.0.4.0.0, using the SQL*Plus tool 8.0.4.0.0

I have a sequence (FieldID) defined as incrementing by 1.

When I insert for example:

insert into tablex

(field_id, field_name)

values
(fieldID.NextVal,'test');

where FieldID is a sequence, the nextval command increments the value by two, thus the first number is 2, the next is 4, etc.

If I use the CurrVal, I get the error:

ERROR at line 1:
ORA-08002: sequence FIELDID.CURRVAL is not yet defined in this session

the statement

select * from user_sequences where sequence_name = 'TABLEX';

SEQUENCE_NAME                  MIN_VALUE MAX_VALUE INCREMENT_BY C O
------------------------------ --------- --------- ------------ - -
TABLEX                                 1 1.000E+27            1 N N

CACHE_SIZE LAST_NUMBER
---------- -----------

20 21

Any help is welcomed. Received on Fri Sep 18 1998 - 17:51:53 CDT