Hi,
I have a problem where from within a store procedure getting executed in a DBase server, say, DB1, I want to connect to another remote database server say DB2 to get something retrieved so that the retrieved info could be used inside the stored procedure on DB1.

How can I do..Any help will be appreciated..
Off course, user id and pwd and IP and SID would be passed as parameters to the stored procedure.

Regards,
Pratap,India

Have you tried using Data Link,

The creation syntax is,
Create Database link test_link connect to scott idetified by tiger using 'test.db';

--Where test.db is the TNS String Name which connects to the remote Dabtabase. This TNS String should be made in your db server pointing to remote DB server.
--Make the DB Link name same as that of GLOBAL_NAME of the remote DB.


Now you can select any table from the remote db using,

select * from emp@test_link;

Sujit

I Just try that, it is ok
But when I receive some row (recordset) from remote database it reponse timeout
????

U can set timeout,the session will be increased.

With thanks
rajesh,
India