OraFAQ Forum: Networking and Gateways » How to detect the DB Link Error

Home » RDBMS Server » Networking and Gateways » How to detect the DB Link Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to detect the DB Link Error [message #121477]

Mon, 30 May 2005 03:01

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

hi all,
if there is a dblink.how can i catch the error if there is any network failure.

with regards
dinesh

Report message to a moderator

Re: How to detect the DB Link Error [message #121486 is a reply to message #121477]

Mon, 30 May 2005 04:06

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

In that case, u wont be able to access objects in remote database (one for which u have established this DBlink).
Whenever u will try to access such objects error will get displayed.

Report message to a moderator

Re: How to detect the DB Link Error [message #121539 is a reply to message #121486]

Mon, 30 May 2005 08:55

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

Thanks,
BUt in my case the procedure is not compiling.And it is also not showing any error.

With regards
Dinesh

Report message to a moderator

Re: How to detect the DB Link Error [message #121567 is a reply to message #121539]

Mon, 30 May 2005 13:23

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

If its not compiling it must be showing some error. Type SHOW ERROR on SQL prompt and check.

Report message to a moderator

Previous Topic:	A question regarding IP addresses
Next Topic:	ora-12535

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 06:13:35 CST 2024