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 <[EMAIL PROTECTED]> 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: '[EMAIL PROTECTED]' > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
