Sequence Problems

From: <rmaddock_at_my-deja.com>
Date: Wed, 28 Jul 1999 13:30:58 GMT
Message-ID: <7nn0mi$sk0$1@nnrp1.deja.com>

I have a database with a number of sequences which I'm using to generate the unique ID's for tables. They are created so:

CREATE SEQUENCE <name> INCREMENT BY 1 START WITH 1 NOCYCLE

I'm using the sequences in INSERT statements from VB6 to Oracle 8 via ODBC and RDO. (E.g. INSERT INTO TABLES (cols...) VALUES (SEQUENCE.NEXTVAL,...)). All is fine for some time but then we get an error saying that a numeric value is out of range for the insert.

I've debugged the code and, using the same values, manually inserted into the table via sqlplus (still using the sequence) without any problems.

The sequence number is hardly any size; only a few thousand.

If I drop and recreate the sequence in question, the problem does not go away. If, however, I drop all the sequences in the database and recreate them then the problem does go away.

Can anyone suggest what is going on?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 28 1999 - 08:30:58 CDT