| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sequence Duplicate values ??
On 16 Oct 1999 23:20:56 GMT, noodles_at_aol.com (Noodles)
wrote:
>Yesterday, I was shown some duplicate numbers that were loaded via PL/SQL using
>'select <seq>.nextval from dual;'. I always thought this was impossible.
It should be impossible. Can you reproduce this? If not, then I'd be more inclined that the PL/SQL program had a bug in it.
>Some possible sources that I've thought about are:
>
>1. rollback within the block during an exception or just general exception ?
Neither of these should affect whether or not a sequence increments.
>2. Oracle 600 errors during execution could cause the seq not to increment ?
Possibly. I've never encountered this. Have you checked the alert log to see if any 600 errors were recorded?
>I was just wondering of there were any common ways of generating sequence
>duplicates ?
Short of recreating the sequence with a beginning value that has already been used before, I don't know _any_ way to do this.
Jonathan
 |
 |