Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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)Received on Wed May 19 2004 - 00:01:39 CDT
![]() |
![]() |