[Q] How to track down a sequence issue?
From: Benjamin G Bielak <dover_at_world.std.com>
Date: Wed, 12 Aug 1998 15:04:56 GMT
Message-ID: <ExL0K8.F9H_at_world.std.com>
One of our sequences is jumping every once in a while by 20. Apparently it is not possible to set up a trigger against a sequence. We are using ORACLE 7. I was wondering if anyone has an idea about how one might be able to track down a sequence issue like this. We have reviewed all the code that calls NEXTVAL on this sequence and nothing jumps out at us as an obvious candidate for the cause of this issue.
Date: Wed, 12 Aug 1998 15:04:56 GMT
Message-ID: <ExL0K8.F9H_at_world.std.com>
One of our sequences is jumping every once in a while by 20. Apparently it is not possible to set up a trigger against a sequence. We are using ORACLE 7. I was wondering if anyone has an idea about how one might be able to track down a sequence issue like this. We have reviewed all the code that calls NEXTVAL on this sequence and nothing jumps out at us as an obvious candidate for the cause of this issue.
TIA
Benjamin Bielak Jr.
dover_at_world.std.com
Received on Wed Aug 12 1998 - 17:04:56 CEST