$loc_sth=$gl_dbh9->prepare($loc_sql_string) or report_die_db( "Can't prepare sql statement" . DBI->errstr.":\n SQL is: $loc_sql_string", (caller(0))[0]. ":".(caller(0))[1]. ":".(caller(0))[2]); #### sub report_die_db{ # # Send emails. # my $message=shift; my $line_number=shift; #my $loc_location_txt = "Package: ".@{$line_number}[0].", file: ".@{$line_number}[1].", line: ".@{$line_number}[2]; print STDOUT $line_number, "\n", $message; my $from = hostname().'@x---------x.com'; my $msg = "There has been an error at line $line_number. \nThe error message is '$message'. "; my $sender = send_email("DB Error at line $line_number", $msg, $from); my $result = $sender->MailMsg({ msg => $sender->{msg}, # file => $sender->{file}, }) or die "$Mail::Sender::Error\n"; die "DB Error" . DBI->errstr; }