| migration oci sequence problem [message #59489] |
Wed, 26 November 2003 08:34  |
Jeroen
Messages: 7
Registered: November 2003
|
Junior Member |
|
|
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
|
|
|
|
| Re: migration oci sequence problem [message #59498 is a reply to message #59489] |
Thu, 27 November 2003 02:42  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Are you sure that the statement was successfully executed? Is the program checking that OCIStmtExecute() returns OCI_SUCCESS?
According to the Oracle9i Call Interface Programmer's Guide: "This OCI release provides support for applications written with either the 7.x OCI or the 8.x or later OCI." Nevertheless, I assume that a recompilation is required (at least - it should be helpful).
You might also want to post a message to the OCI Forum. I'm sure they will be able to assist you.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
