Re: How to test Dblink is Up or not

Brij wrote:

> How to test Dblink is Up or not
>
> 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

SELECT COUNT(*)
INTO i
FROM dual_at_db_link_name;

In a block with an exception handler.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)