Hi All
Happy New Year
In my plsql program i am connecting to two remote DBs and using db_links
sequentially.
Sometimes if the first remote db is not available or there is some network problem then it stays there for quite some time and then throws an error (which is captured in exception section). then it goes to the next block and does the work using the second db_link to the second DB.
Can I reduce the time of oracle trying to get the connection of the remote Db before throwing the error.
Basically i want to try for a shorter time to try connecting to a remote db and if not possibe then to go ahead.
Thanks and Regards
B S Pradhan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: bhabani s pradhan
INET: bhabaniindia_at_rediffmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jan 02 2004 - 01:44:24 CST
