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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Auto-increment sequence

Re: Auto-increment sequence

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Thu, 14 Nov 2002 21:37:38 GMT
Message-ID: <3DD417A2.8BF03023@peasland.com> 





> I can't agree 100% with Daniel, it will *reduce* the instances of lost

> numbers but the INSERT INTO error_log may also get rolled back or fail

> under some circumstances.




True, and CURRVAL will not work unless NEXTVAL has already been selected
in that session. Otherwise, one will get the ORA-8002 error.



HTH,



Brian
Received on Thu Nov 14 2002 - 15:37:38 CST












Original text of this message













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