NextVal quirk
From: Patrick Janidlo <janidlo_at_visionarysoftware.spamthis.com>
Date: Fri, 18 Sep 1998 14:27:43 -0500
Message-ID: <GAxM1.1104$AT4.5721879_at_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
Date: Fri, 18 Sep 1998 14:27:43 -0500
Message-ID: <GAxM1.1104$AT4.5721879_at_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';
gets
SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C OCACHE_SIZE LAST_NUMBER
------------------------------ --------- --------- ------------ - - -------- -- ----------- TABLEX 1 1.000E+27 1 N N 20 21
Any help is welcomed. Received on Fri Sep 18 1998 - 21:27:43 CEST