Re: Trigger goes only to 1000 and Stops

Hi!
changing the step value helped...
seems like somebody entered a datarow by hand with the ID 1000.

thanks to all,
Arash.

Atul Agrawal <atul_ce_at_yahoo.com> wrote in message news:<3C92C2AF.138AB1DB_at_yahoo.com>...
> try changing the step value to two and see if the problem actually lies
> within yor program or the trigger..
>
> also you could catch this particular exception and try printing the sequece
> number at which it is giving error, to find where the problem actually
> lies...
>
> take care
> Best of luck
>
> atul
>
> Arash wrote:
>
> > Hi!
> > I have a Problem with a Trigger in ORACLE8i.
> > I have a table with a Trigger creating the ID.
> > The Trigger is increasing a Sequence, that has MINVALUE 1, MAXVALUE 1.0E27
> > and STEPVALUE 1.
> >
> > Now, since the Sequence reached the value 1000, I get an
> >
> > ORA-00001: unique constraint (INTRANETUSER.PK_IDUSER) violated
> >
> > every time I try to INSERT new Data through an ASP-Script.
> >
> > Anyone knows what that is all about?
> > thanx, Arash.
>
> --
>
> Atul Agrawal | Atul Agrawal
> Masters Student, CS Deptt. | 3501, St Paul Street,
> Johns Hopkins University | Apt # 1018,
> 3400, N Charles Street, NEB 224 | Baltimore,
> Baltimore, MD 21218. | MD 21218.
> |
> Hello: 410-516-8291 (Lab) | Hello: 410-366-6852 (Resi)
Received on Mon Apr 08 2002 - 05:46:30 CDT