eval { # try
   $sth->execute(); #throw
};

if ($@) { #catch
   if (<error text indicates a recoverable statement handle error) {
       ...delete cached statement handle, re-prepare SQL
       and re-execute...
       }
}