>
> Hi Folks,
>
> I've been leading you (and myself) on a wild goose chase. My problem
> occurs even when the trigger is disabled.

Hmmm

I've burnt my fingers a number of times with insert triggers setting the PK
value from a generator, whilst the generator value is lower than the current
highest value of the PK.... For each "PK exception", the generator is still
incremented by one, until it's higher than the current highest PK value,
upon which the errors misteriously disappear (this is one case where user
persistence will actually help, they simply need to retry inserting a new
record until the error goes away)

My R 0.02

Donald Klopper