Hi,
I am having Multiple oarcle database server with same schema. sometimes i
have to access other database server to get some information for that i am
using dblink.
Now my problem is if because of some network error or due to link failure if
i can not connect to database specified by DBlink then it goes into a long
wait...
Is there any way to first test DBLINK whether it's Up or not and then
proceed using Sql stored procedure or Developer 2k.
Brij

The problem may not be the connection to the database. It may be to
retrive data. I would say try "select sysdate from dual@dblink" and
see how long this takes. if this returns the data fast then it is the
data which is taking long time and not the connection.

Hope this helps.
Mir