Thanks Jared, Mark and Larry, I realized that the SQLNET.ORA paramet SQLNET.EXPIRE_TIME might help me here. And it looks like I might be able to test it today - our network is losing it's mind again. thanks Tom Mercadante Oracle Certified Professional -----Original Message----- From: Jared Still [mailto:jkstill@xxxxxxxxxx] Sent: Thursday, June 24, 2004 10:28 AM To: Oracle-L Freelists Subject: Re: Database Link Timer PL/SQL does not have signals. If you wrote this in a language that was more suited to systems programming, such as oh, say, Perl, this would be easy. And no, I am not being facetious. PL/SQL is not an appropriate tool for this kind of work. You may be able to do this in Java, but I don't know. Jared On Thu, 2004-06-24 at 05:08, Mercadante, Thomas F wrote: > All, > > I have the following query in a stored package: > > select 1 into loc_variables from dual@databaselink > <mailto:dual@databaselink> ; > > What I am doing is checking the availabilty of the remote database > periodically. The bad news is that we sometimes have network > problems. If the above would fail, then I trap the error and move on. > But sometimes, it is just painfully slow (like it doesn't fail but > hangs for a long time). > > Is there some way I can put a timer on the above that says if it can't > complete the query in 10 seconds, then fail? > > thanks > > Tom Mercadante > Oracle Certified Professional > > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put > 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------