Duplicate Sequence Values ?

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:

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

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

Stumped in Pennsylvania,
Cliff Received on Sat Oct 16 1999 - 18:21:30 CDT