DUVIDA Trigger BD

DELIMITER $$
DROP PROCEDURE IF EXISTS genSync$$
CREATE PROCEDURE genSync(
IN id_ciclo VARCHAR(255),
IN mdt VARCHAR(255),
IN user VARCHAR(255),
IN senha VARCHAR(255),
IN ip varchar(255),
IN id_sys VARCHAR(255),
IN idioma VARCHAR(225),
IN dt_ini VARCHAR(255),
IN hora_ini VARCHAR(255),
IN id_ciclo VARCHAR(255),
IN rfc VARCHAR(255),
IN sap_tab VARCHAR(255),
IN intern_tab VARCHAR(255)
)

BEGIN
DECLARE durac INT DEFAULT 0
DECLARE repet INT DEFAULT 0
DECLARE count INT DEFAULT 0
DECLARE ins_data VARCHAR(255)
DECLARE sch_id VARCHAR(255);

SET ins_data = ' ';

SELECT dias 
INTO repet
FROM ciclo c, repeticao r
WHERE c.repeticao_id = r.id
AND c.id = id_ciclo;

SELECT dias 
INTO durac
FROM ciclo c, duracao d
WHERE c.duracao_id = d.id
AND c.id = id_ciclo;

INSERT INTO SCHEDULE_SYNC
(ciclo_id,data,hora,mandante,user,pass,idioma,ip,system)
VALUES 
(id_ciclo,dt_ini,hora_ini,mdt,user,senha,idioma,ip,id_sys);

SELECT last_insert_id
INTO sch_id;

WHILE count <= (durac / repet) DO

SELECT DATE_ADD(data, INTERVAL repet DAY)
INTO ins_data
FROM SCHEDULE_SYNC
WHERE DATA = dt_ini
AND HORA = hora_ini;


INSERT INTO SYNCS (insdata,sch_id);
VALUES


END WHILE

END$$
DELIMITER;