Sequence Duplicate values ??

From: Noodles <noodles_at_aol.com>
Date: 16 Oct 1999 23:20:56 GMT
Message-ID: <19991016192056.13489.00000246@ng-ff1.aol.com>

environment: HP 10.x; Oracle 8.0.5

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.

Some possible sources that I've thought about are:

rollback within the block during an exception or just general exception ?
Oracle 600 errors during execution could cause the seq not to increment ?
...

I was just wondering of there were any common ways of generating sequence duplicates ?

Stumped in Pennsylvania,
Cliff
(noodles_at_aol.com) Received on Sat Oct 16 1999 - 18:20:56 CDT