RE: DBI connections to oracle sometimes hang

2005-01-20 Thread Reidy, Ron
You could set up a SIG{ALARM} and the attempt the connection. Or better still, get your DBAs to fix the problems in the DBs. - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: David Goodman [mailto:[EMAIL PROTECTED] Sent: Thursday, January 20, 2005

RE: DBI connections to oracle sometimes hang

2005-01-20 Thread Hardy Merrill
I've never done this, but Ron's advice ($SIG{ALRM}) is in line with the DBI perldocs. Here is a snippet from 'perldoc DBI' - I searched for timeout: Signal Handling and Canceling Operations The first thing to say is that signal handling in Perl is currently *not* safe. There is always