Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> sequence generator

sequence generator

From: Ravindra Basavaraja <ravindra_at_sentica.com>
Date: Fri, 23 Feb 2001 16:29:48 -0800
Message-ID: <F001.002BC870.20010223163026@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US