Home » RDBMS Server » Server Administration » triggers and sequences
triggers and sequences [message #370446] Fri, 24 September 1999 15:23
Amy
Messages: 29
Registered: September 1999
Junior Member
I have a table that I insert a value of 0 into one of the colums which fires an insert trigger. That trigger updates the value from 0 to nextval from a sequences. However, my sequence is generating strange numbers (30, then 40) and I keep getting duplicates on that field (it's my pk). Help please!

Notes:
my sequence starts at 1, inc by 1, order values no cache

my trigger code: (after insert)
update table set col = next_simid.nextval where
col = 0;
Previous Topic: How to compare pre-image and post-image after update and before commiting
Next Topic: Help on DBMS_ALERT
Goto Forum:
  


Current Time: Thu Mar 28 17:42:51 CDT 2024