| 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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
