Create Procedure Generating Errors

[Subramanian Mayuranathan]

Hi All,

I have just started with MySQL. Trying to create a SP like so. But unable as MySQL throwing many errors

CREATE PROCEDURE IF NOT EXISTS db_dentalclinic.sp_AddTreatmentRecord IN (appointmentid int, natureoftreatment varchar, treatmentrendered VARCHAR, toothno tinyint, treatmentcomplete text, treatmentdate date, OUT Saved int)

DELIMITER //

DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
select 0 into Saved;
ROLLBACK;
RESIGNAL;
END;
BEGIN

START TRANSACTION;
insert into tblTreatments (appointmentid, natureoftreatment, toothnumber, treatmentcomplete, treatmentdate)
VALUES
(appointmentid, 'Root Canal Treatment', toothnumber, 1, CURRENT_DATE());

insert into tblTreatmentHistory (treatmentid, treatmentrendered, posttreatmentadvice, treatmentdate, treatmentcomplete, followupdate, materialsused)
VALUES
(LAST_INSERT_ID(), treatmentrendered, posttreatmentadvice, CURRENT_DATE(), 1, CURRENT_DATE(), materialused);

select LAST_INSERT_ID into Saved;
COMMIT;


END//
DELIMITER ;