Sequence question

From: Witold Iwaniec <wiwaniec_at_novalistech.com>
Date: Wed, 19 Jun 2002 11:13:36 -0800
Message-ID: <F001.00481B07.20020619111336@fatcity.com>

Hi all

We have experienced strange behaviour with a sequence, or we think it is sequence...

In a long process we get a value from a sequence, submit a record, get next value, submit next record etc.

Sometimes we get an error - it seems that the sequence call doesn't return any value. We see the null value in the process log. So:
- we run the process, get values form the sequence, submit records

• after number of iterations the value returned by "SELECT the_sequence.nextval FROM DUAL" is null
• after further number of iterations we start getting values from the sequence again

When we run it multiple times, the problem repeats although the number of iterations to get to the nul values and number of iterations with null values is different.

Has anyone experienced similar problem in Oracle or can explain why it can happen?

The problem may be outside of Oracle - it is an OCI program (written in C++). But we look for different reasons.

Thanks

Witold

---

Witold Iwaniec
Sr Software Developer
NovaLIS Technologies
wiwaniec_at_novalistech.com
http://www.novalistech.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: wiwaniec_at_novalistech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jun 19 2002 - 14:13:36 CDT