Не работает триггер в MySQL

CREATE 
DEFINER=`admin`@`%` 
PROCEDURE StatForCall ()
BEGIN
SET @comercial:=0;
SET @s = CONCAT('SELECT 1 INTO @comercial FROM `statistic`.',@stattbl,' as stat, `city_',@city,'`.firm WHERE file="',@file,'" and stat.fid=firm.fid and end_date>=Now() limit 1;');
PREPARE stmt1 FROM @s;
EXECUTE stmt1;
SELECT @comercial;
DEALLOCATE PREPARE stmt1;
END;

CREATE TRIGGER `update_cdr`   
AFTER INSERT ON `cdr`   
FOR EACH ROW BEGIN    
IF NEW.dst = 130 THEN
SET @strlen := LENGTH (NEW.userfield)-3;
SET @strpos := INSTR ( NEW.userfield, 'cid_')+4;
SET @strcount := @strlen-@strpos;
SET @city := SUBSTRING(NEW.userfield, @strpos, @strcount);
SET @oper_line := SUBSTRING(NEW.dstchannel, 5, 4);  
 
SET @strpos := INSTR ( NEW.userfield, '_')+1;
SET @strlen := INSTR ( NEW.userfield, '_id_');
SET @strcount := @strlen-@strpos;
SET @number := SUBSTRING(NEW.userfield, @strpos, @strcount);
 
SELECT oper_id INTO @oper_id  FROM `call_center`.`oper_work`  WHERE line=@oper_line order by id desc limit 1;  
 
SET @file=SUBSTRING(NEW.userfield, 10, 80);
SET @stattbl:=DATE_FORMAT(NOW(),'s%Y_%m');
 
CALL StatForCall();
 
INSERT INTO  `call_statistic`.`sc2013_03` Set city=@city , oper_id=@oper_id, dt=NEW.calldate, filename=NEW.userfield, billsec=NEW.billsec, duration=NEW.duration, clid=@number, comercial=@comercial;   
END IF;
END;

DELIMITER |

|
DELIMITER ;