Re: Sequence Problems

In article <7nn0mi$sk0$1_at_nnrp1.deja.com>,   rmaddock_at_my-deja.com wrote:

WHOOPS! Seems to have posted to the wrong place, sorry.

> 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.
>

--

Robert Maddock

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 29 1999 - 09:06:01 CDT