dblinks

Need advice on solving this:

I've got some stored procedures on DB_X which updates some tables on DB_X but needs to get data from DB_Y. The use of dblinks works fine but I need a solution in which a user can enter connection-data (table DATASOURCES) in a table at DB_X som that the stored procedures can use this info to connect to a remote database (DB_Y) and get data.

Table DATASOURCES:

id        sid    ip                            port        username    prw
aaa    test1    123.123.123.123    1521    scott            tiger
bbb    test      321.321.321.321    1521    scott           tiger

I've tried with dynamically creating and dropping dblinks, but it seems like the dblink-name has to exsist in tnsnames.ora at DB_X. My solution can't depend on entries in tnsnames.ora at DB_X.

Therefore i'm looking for something like this (but then I've got no username/pwd):

select colA from tabA_at_123.123.123.123:1521:test1 where colB=xxx;

suggestions?

-eirik- Received on Mon Jan 13 2003 - 13:31:17 CET