SQL EXEC prob 7.3.4 - 9.2

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Fri, 11 Jun 2004 09:42:04 -0500
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B8508B23@okcexg3.kmg.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Jun 11 2004 - 09:39:22 CDT