CREATE PROCEDURE `spDeleteAssignTeacherContent` ( IN `P_ContentId` INTEGER ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN SELECT ? ; END ; START TRANSACTION ; DELETE FROM `tteachercontentassign` WHERE `Id` = `P_ContentId` ; SELECT ? ; COMMIT ; END 