sql Error>> Dynamic SQL is not allowed in stored function or trigger

DELIMITER //
CREATE TRIGGER `test11` BEFORE UPDATE ON batch FOR EACH ROW
BEGIN
  DECLARE proud Double;
  DECLARE result_position int;
  DECLARE result_all int;

  DECLARE date1 date;
  DECLARE cust varchar(100);
  SET @result_position = 1;   
 
  DELETE FROM temp;
  SELECT COUNT(Batch_Date) INTO @result_all FROM batch WHERE Batch_date BETWEEN DATE_SUB(NOW(), INTERVAL 25 DAY) AND NOW() ;
         
  lab: LOOP
    PREPARE STMT FROM 'SELECT Batch_Date,Customer_Code,Production_Qty INTO @date1,@cust,@proud FROM batch WHERE Batch_date BETWEEN DATE_SUB(NOW(), INTERVAL 25 DAY) AND NOW() LIMIT ? , 1' ;
    EXECUTE STMT USING @result_position ;

    INSERT INTO temp (Batch_Date,Customer_Code,Production_Qty) VALUES(@date1,@cust,@proud);
    SET @result_position = @result_position + 1;

    if @result_position  > @result_all then
     LEAVE  lab;
    end if;
  END LOOP;

  END
  //

DELIMITER ;