Re: Trigger goes only to 1000 and Stops

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)