Database

DELIMITER $$

DROP PROCEDURE IF EXISTS CleanCopyEnvData$$

CREATE PROCEDURE CleanCopyEnvData ()
BEGIN

  insert into  EnvData(UserDate, XAction, Balance, UserID)
  select 
    CAST(udate as Date)
    , CAST(amount1 as Decimal(6,3))
    , CAST(amount2 as Decimal(6,3))
    , CAST(UID as UnSigned)
  from 
    DataLoad;
    
END $$

DELIMITER ;

Error starting at line : 17 in command -
END $$
Error at Command Line : 17 Column : 1
Error report -
SQL Error: 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 'END $$' at line 1