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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
