Ron,
It is more likely to be a library compatibility problem between the user and server side sql*net layers. My guess is that some of your .o or possibly even .pc files have not been regenerated (there may be subtle differences in the C code generated by the 7.3 and 9.2 proc).
I'd first try to
touch *.pc
and then regenerate all executables from there.
Regards,
Stephane Faroult
On Fri, 11 Jun 2004 09:42 , 'Smith, Ron L.' <rlsmith@xxxxxxx> sent:
We are upgrading one of our application to Oracle 9.2, it was 7.3.4.
The following code works when connecting to the old 7.3.4 app but not to
the new 9.2 app.
Could this be a tnsnames or dblink problem?
Thanks!
Ron
EXEC SQL
CONNECT :USERID-ORA-IPRM
IDENTIFIED BY :PASSWD-ORA-IPRM
AT :DB-SID-ORA-IPRM
USING :DB-TNSNAME-ORA-IPRM
END-EXEC.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
