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]
