sequences can IIRC be set so that they wrap after hitting an upper
limit.This sounds like the sort of thing that will bite after running for
sometime with no trouble. It would also explain the 20% or so that work -
deleted records.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
<dileepr_at_my-deja.com> wrote in message news:95vlc1$tu4$1_at_nnrp1.deja.com...
> I have been using a d2k developed package for over a year without
> problem but recently I am unable to save transactions where a sequence
> generated "nextval from dual" number has to be inserted into a table.
> Message I get is the number is not unique. I am surprised because
> oracle is supposed to generate unique sequential numbers from any
> sequence. Or am i wrong?
>
> Can somebody please give me the solution?
>
> The funny part is that some inserts go through but most(about 80%) fail
> and give a duplicate number message.
>
>
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Feb 09 2001 - 09:03:39 CST
