| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> sequence generator
Can anyone correct/confirm the following:
A sequence generated number is auto committed. i.e if the transaction that
generates
the sequence number fails which eventually gets rolledback the generated
sequence number
generated is lost and not available for the next transaction.
Is there by anyway prevent lossing of the sequence generated number in case
of the
transaction that generated it fails.Any work around?
The problem is, with this happening finnally the column that will have the
sequence genarted
number will not be continuous set of numbers.
I needed a second opinion on the above points.
Thanks
Ravindra
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ravindra Basavaraja
INET: ravindra_at_sentica.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Feb 23 2001 - 18:29:48 CST
 |
 |