eval { $dbh->do("DELETE FROM MASTER1 WHERE mrID=999"); $dbh->do("INSERT INTO MASTER1 (mrID) VALUES (999)"); $sql = "UPDATE MASTER1 SET mrDESCRIPTION=? WHERE mrID=999"; $sth = $dbh->prepare($sql); $sth->bind_param(1, $data, DBI::SQL_LONGVARCHAR); $sth->execute(); $dbh->commit(); };