Thankfully we are running 8.1.6.0.0.
>Hi there.
>
>I know it has been 2 weeks, but I thought I might reply with a warning.
>
>If you are running 8.1.5 there is a BUG that stops this from always working correctly. If you insert multiple rows at once (e.g by INSERT INTO .. SELECT FROM .. ) then you will get duplicate PKs!
>
>I tried logging this bug with Oracle support last November, but they told me that as Oracle 8.1.5 was desupported as at 1st Jan, they couldn't be bothered checking it.
>
>This bug has gone in 8.1.6!
>
>Les
>
>>create sequence S_NPDES_ADDRESS_HISTORY
>>increment by 1
>>start with 1 nocache;
>>
>>create or replace trigger ADDRESS_HISTORY_BEFORE_INSUPDT
>>before insert or update on npdes.ADDRESS_HISTORY for each row
>>declare
>>v_Id Number;
>>BEGIN
>> :new.Updated_By := USER;
>> :new.Last_Update := SYSDATE;
>> If :new.KeyID Is Null or :new.KeyID < 1 Then
>> select S_NPDES_ADDRESS_HISTORY.nextval into v_Id from dual;
>> :new.KeyID := v_Id;
>> End If;
>>End;
>>/
>>
>>>Hi everyBody
>>>
>>>I work with VB5 and I have DataBase on Oracle 8.
>>>
>>>I have Create a sequence
>>>
>>>CREATE SEQUENCE IdPoste_Seq
>>>START 1
>>>INCREMENT BY 1
>>>
>>>
>>>My Application is a Client/Server and some time two users work with his SEQUENCE and one of them find a Seqence Numnber Invalide.
>>>
>>>I Use this Sequence on the primary Key on my Tble POSTE
>>>
>>>SomeOne have or had his Erreur
>>>
>>>Thanks for your help!
Mark McCasland
Midlothian, TX USA