执行存储过程出错

DELIMITER $$



USE `db_offsmplroom`$$



DROP PROCEDURE IF EXISTS `UpdateMcode`$$



CREATE DEFINER=`root`@`localhost` PROCEDURE `UpdateMcode`(

    IN mcode VARCHAR(20),

    IN btype VARCHAR(50),

    IN stype VARCHAR(50),

    IN mname VARCHAR(255),

    IN mcolor VARCHAR(200),

    IN ecode VARCHAR(50),

    IN munit VARCHAR(50)  

    )

    

BEGIN

    DECLARE back INT;

    IF LENGTH(mcode)<=0 OR LENGTH(btype)<=0 OR LENGTH(stype)<=0 OR LENGTH(mname)<=0 OR LENGTH(stype)<=0 THEN

    #SELECT * FROM material;

    SET back=1;

    SELECT back;

    END IF;

    SET back=0;

    SELECT back;

    # SELECT * FROM material;

    END$$



DELIMITER ;