Home » SQL & PL/SQL » SQL & PL/SQL » Remote Database exception handling
Remote Database exception handling [message #248710] Sat, 30 June 2007 23:10 Go to next message
S384492
Messages: 7
Registered: June 2007
Junior Member
Hi,
I have a procedure , with in this procedure i am calling another procedure which is at remote db. How to handle the exception when remote db is down. Any clue.......
Re: Remote Database exception handling [message #248713 is a reply to message #248710] Sat, 30 June 2007 23:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> How to handle the exception when remote db is down
Why is this exception different from any other exception?
It is handled by the exception code you write to do what you deem appropriate.
Re: Remote Database exception handling [message #248714 is a reply to message #248710] Sat, 30 June 2007 23:20 Go to previous messageGo to next message
S384492
Messages: 7
Registered: June 2007
Junior Member
hi,
I don't which exception will handle this one. pls let me know which exception will handle this one.
Re: Remote Database exception handling [message #248718 is a reply to message #248710] Sat, 30 June 2007 23:42 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
1)Implement original code without exception handler.
2)Verify that it works as desired.
3)Shutdown remote database.
4)Repeat prevous test (#2)
5)Record error thrown.
6)Implement desired exception handler.
7) go to #4

[Updated on: Sat, 30 June 2007 23:43] by Moderator

Report message to a moderator

Previous Topic: Comapring tables from two databases
Next Topic: Murging with excel
Goto Forum:
  


Current Time: Tue Feb 11 03:13:15 CST 2025