|Subject:||Database link and JDBC|
|Date:||19 Jan 2004|
I 'm working with 2 databases Oracle v9.2 : DB1 and DB2.
I setup a database link from DB1 to DB2.
I've created a SP which joins between tableA from DB1 and tableB from
This sp works fine from an sql+ session on the DB1 server.
However, when I'm executing this sp via JDBC (oracle thin driver) from
a java app, it triggers an SQLException : ORA-12154 TNS. Could not
resolve service name error.
The error line number points to the line in the procedure where tableA
and tableB are joined ...
Any ideas ?