RE: migration sequence oci problem

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Thu, 27 Nov 2003 10:24:45 -0800
Message-ID: <F001.005D8063.20031127102445@fatcity.com>

Jeron,

I don't know if it would help any, but if it is a DB issue, event 10217 might be useful:

$ oerr ORA 10217
10217, 00000, "debug sequence numbers"
// *Cause:
// *Action:

I have never used it myself before, but if you push support a bit maybe they might provide details on how this can be used. I've just experimented with it a bit now, but to no avail - just setting it alone and/or combined with 10046 doesn't seem to make much difference.

Thanks,
Boris Dali.

• Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl> wrote: > We could narrow it down to the value of the sequence
  > exceeding
  > 16777216 (2 to the power of 24)
  > This looks familiar as described in bug 2573172
  > This bug describes to change the type in the odefin
  > call to type 3 but this
  > doesn't help.
  > I know this is not really a dba issue now anymore
  > but I'm desperate for any
  > advice because I don't have any developers
  > left with oci-knowledge
  > Tnx,
  > Jeroen
  >
  >
  > -----Oorspronkelijk bericht-----
  > Van: Jeroen van Sluisdam
  > Verzonden: Wednesday, November 26, 2003 16:40
  > Aan: 'oracle-l_at_fatcity.com'
  > Onderwerp: migration sequence oci problem
  >
  >
  > Hi,
  >
  > We're testing an oracle 9.2.0.4 database with an
  > oracle 7 client.
  > This is a C++ client, using OCI to go to oracle.
  > We see strange behaviour when using a sequence which
  > worked
  > nicely before. The sequence is not incremented when
  > issueing
  > "select res_id.nextval from dual
  >
  > When I test this with an oracle 7 sqlplus client
  > this works also
  > as expected.
  >
  > Is there any known bug or issue known with migrating
  > oci-applications.
  > According to manuals it shouldn't be a problem and I
  > cannot find any
  > problems
  > on metalink about this.
  >
  > Thanks in advance,
  >
  > Jeroen
  >
  

  ---

Post your free ad now! http://personals.yahoo.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boris Dali
  INET: boris_dali_at_yahoo.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Thu Nov 27 2003 - 12:24:45 CST