DB Link Problem [message #110347] |
Sun, 06 March 2005 07:08 |
fanni
Messages: 96 Registered: March 2004
|
Member |
|
|
AOA
I am Using a DB Link to in one of my form .
When ever remote database goes down, and i call the procedure using the DB Link. The application is halted for about 60 seconds. there i have placed the exception
exception WHEN OTHERS THEN.
message('Remote DB is Down');
Although the application does not crash but it takes about 60 seconds when ever the remote DB is down the DB link is used. Can i handle it in the way that if DB is down and DB link is used . It just gives a message instantly that 'REMOTE DB IS DOWN'.
I want to make my application efficient and reduce this delay.
How can i check the status of Remote DB.
Any idea ???
|
|
|