I AM TRYING A SP BUT IT IS NOT SAVING AND WORKING.DOES THE STORED PROCEDURE WORK PARTLY? BELOW IS MY QUERY

DELIMITER$$

DROP PROCEDURE IF EXISTS `test_query`.`updt_cls_cat_name`$$

CREATE PROCEDURE `test_query`.`updt_cls_cat_name`()

    BEGIN
    DELETE FROM FEE_CLASS_CATEGORY_NAME;
    ALTER TABLE FEE_CLASS_CATEGORY_NAME AUTO_INCREMENT=20;
    INSERT INTO FEE_CLASS_CATEGORY_NAME(CLASS_CATEGORY_ID) SELECT CLASS_CATEGORY_ID FROM FEE_CLASS_CATEGORY;
    UPDATE FEE_CLASS_CATEGORY_NAME
SET CLASS_CATEGORY_NAME= CASE
    WHEN CLASS_CATEGORY_ID=1
THEN 'LOWER'
    WHEN CLASS_CATEGORY_ID=2
THEN 'MEDIUM'
    WHEN CLASS_CATEGORY_ID=3
THEN 'HIGH'
END;
    END$$

DELIMITER;

ALL THESE QUERIES OUTSIDE THE STORED PROCEDURE'S BODY ARE WORKING PROPERLY. BUT WHEN I AM TRYING TO EXECUTE THEM INSIDE IT. IT IS SHOWING ERRORS. I TRIED REMOVING THE DELIMITER KEYWORD, BUT IT IS STILL THE SAME. I AM ALSO PUTTING THE GENERATED ERROR.

(0 row(s)affected)
(0 ms taken)

(0 row(s)affected)
(0 ms taken)

Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER' at line 1 (0 ms taken)