See this section of the DBI pod: http://search.cpan.org/~timb/DBI-1.609/DBI.pm#Signal_Handling_and_Canceling_Operations
which references this: http://search.cpan.org/~lbaxter/Sys-SigAction/ Lincoln On Mon, 2009-09-28 at 16:51 -0400, Matthew Dougherty wrote: > I have perl programs with persistent connections to oracle via DBI. > > It seems that when the connection dies, the perl script freezes without any > error output. > > I have a manager script that detects no output, kills and restarts it but I'm > wondering if there is a way to trap the error. > > All of my transactions are wrapped in eval statements. > > The reason it's an issue is that the DB is unavailable so often, I need a > better error than inactivity to help the DBA group track down the root cause > (backups?). > > I seem to remember this being discussed before but I am not finding it when I > search. > > Any help would be appreciated. > > Perl 5.8.0 > DBI: 1.603-1 > DBD/Oracle.pm: 1.20 > Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production > > Thanks, > > Matt. > > Matthew Dougherty > [email protected] >
