Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id hASMRZs03987 for ; Fri, 28 Nov 2003 16:27:35 -0600 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id hASMRYc03982 for ; Fri, 28 Nov 2003 16:27:34 -0600 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id hASJRS230637 for oracle-l@orafaq.net; Fri, 28 Nov 2003 11:27:28 -0800 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D8179; Fri, 28 Nov 2003 11:29:26 -0800 Message-ID: Date: Fri, 28 Nov 2003 11:29:26 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Jeroen van Sluisdam Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Jeroen van Sluisdam Subject: RE: migration sequence oci problem Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3B5E5.3DDFA0F0" ------_=_NextPart_001_01C3B5E5.3DDFA0F0 Content-Type: text/plain It's solved. The oci-code must be changed when going from oracle 7 to Oracle 8 or 9. When a sequence.nextval is called using a float_type you get returned Duplicates. Not only the type of column returned must be changed but the buffer etc .. also Thanks, Jeroen -----Oorspronkelijk bericht----- Van: Jeroen van Sluisdam [mailto:jeroen.van.sluisdam@vrijuit.nl] Verzonden: donderdag 27 november 2003 19:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: migration sequence oci problem 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@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 ------_=_NextPart_001_01C3B5E5.3DDFA0F0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable

It's solved. The oci-code must be changed when going from oracle 7 to =

Oracle 8 or = 9. When a sequence.nextval is = called using a float_type you get = returned

Duplicates. Not only the = type of column returned must be changed but the buffer etc = .. also

=

Thanks,

=

Jeroen

=

=

-----Oorspronkelijk bericht-----
Van: = Jeroen van Sluisdam [mailto:jeroen.van.sluisdam@vrijuit.nl]
Verzonden: donderdag 27 november 2003 = 19:09
Aan: Multiple recipients = of list ORACLE-L
Onderwerp: RE: migration = sequence oci problem

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@fatcity.com'
Onderwerp: migration = sequence oci problem

&= nbsp;

Hi,

&= nbsp;

We'= re testing an oracle 9.2.0.4 database with an oracle 7 = client.

Thi= s is a C++ client, using OCI to go to = oracle.

We see strange behaviour when using a sequence which worked =

nic= ely 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

------_=_NextPart_001_01C3B5E5.3DDFA0F0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: jeroen.van.sluisdam@vrijuit.nl 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@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).