Re: Duplicate Sequence Values ?

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Mon, 18 Oct 1999 17:56:00 GMT
Message-ID: <QaJO3.64$p%6.1790370@France.EU.net>

Hi Noodles !

What is when you make :
SELECT 'x' from DUAL ?

Noodles <noodles_at_aol.com> a écrit dans le message : 19991016192130.13489.00000247_at_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:
>
> 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 Mon Oct 18 1999 - 12:56:00 CDT