Re: Sequence question

Hi Witold,

I had a similar problem with VB. When I run "select sequence.nextval from dual;" in a loop , sequence was increasing 2 by 2 .. So I made a function in database and function returned the nextval to VB program and every thing was now well. You can try this and simpy understand where the problem is . If still the problem contuniues , then situation is worse , you may have to go deep inside OCI.

Bunyamin Karadeniz
Oracle DBA
Havelsan A.S. Eskisehir yolu 7.km
Ankara / Turkey
Tel : +90 535 3357729

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 19, 2002 10:13 PM

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bunyamin Karadeniz
  INET: bunyamink_at_havelsan.com.tr

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).