Re: Getting NEXTVAL just prior to a COMMIT
From: Scott Lawrence <73774.424_at_CompuServe.COM>
Date: 1995/09/12
Message-ID: <432p3q$ha1$4_at_mhadg.production.compuserve.com>#1/1
Date: 1995/09/12
Message-ID: <432p3q$ha1$4_at_mhadg.production.compuserve.com>#1/1
Two solutions:
As stated previously - however we have used pre-insert triggers
in the past.
The preferred method, if you don't care about losing numbers, which you really shouldn't if they are internal id's. Is to specify the sequence nextval in the default property of the field holding the number.
ie. default: :sequence.sequence_name.nextval
Scott Lawrence
Rock Ridge Computer Services
ORACLE Application Development
Received on Tue Sep 12 1995 - 00:00:00 CEST