pastebin

DELIMITER $$

drop PROCEDURE if exists `transferEmailTempData`$$

create PROCEDURE transferEmailTempData(in jobId VARCHAR(24))

BEGIN

DECLARE idval VARCHAR(24) default '';

DECLARE taskIdval VARCHAR(24) default '';

DECLARE groupIdval VARCHAR(24) default '';

 

DECLARE emailval VARCHAR(50) default '';

DECLARE infoId VARCHAR(24) default '';