我尝试动态访问表名，有很多表，但它只处理第一个表和循环中断。你知道我会做错什么吗

PROCEDURE IF EXISTS pmms.TdevidendPaymentOnSavings;

  DELIMITER //

   CREATE PROCEDURE TdevidendPaymentOnSavings() READS SQL DATA BEGIN

     DECLARE accountNumber VARCHAR(30);DECLARE tableName VARCHAR(30);DECLARE 
     theAccountDate1 DATE;

     DECLARE anyDateInYear DATE;DECLARE rateUsed INTEGER;DECLARE lastDate 
     DATE;

    DECLARE ledgerBalance1 INTEGER;DECLARE amountComputed INTEGER;DECLARE 
    monthlySummations INTEGER;

   DECLARE monthlyTotals INTEGER DEFAULT 0; DECLARE l_done INTEGER;DECLARE 
    finalTotals INTEGER DEFAULT 0;

    DECLARE forSelectingAccountNumbers CURSOR FOR SELECT account_number  
  FROM 
   pmms.account_created_store WHERE account_number LIKE '05502%10';

      DECLARE CONTINUE HANDLER FOR NOT FOUND SET l_done=1;

   SET l_done=0;

  SELECT SavingsStartDate,SavingsRateUsed INTO anyDateInYear,rateUsed from 
    SavingsSharesComputationParameters;

    OPEN forSelectingAccountNumbers;

  accounts_loop: LOOP 

  FETCH forSelectingAccountNumbers into accountNumber;

  IF l_done=1 THEN

  LEAVE accounts_loop; 

    END IF;

  SET tableName=CONCAT('bsanca',accountNumber);

  CALL accountNma(accountNumber,@accountName);

  SELECT tableName,accountNumber;

  SET @sql_text1 = concat('SELECT ledger_balance INTO @ledgerBalance from  
 ',tableName,'  WHERE trn_date=@theAccountDate ORDER BY trn_id DESC LIMIT 
 1');

 SELECT @sql_text1;

 SELECT @ledgerBalance ;SELECT @theAccountDate;
 PREPARE stmt1 FROM @sql_text1;
 EXECUTE stmt1;
  DEALLOCATE PREPARE stmt1;

 END LOOP accounts_loop;

  SET l_done=0;

 CLOSE forSelectingAccountNumbers;

  END//

   DELIMITER ;

我已经检查过无数次了，但是当我正确地删除准备好的语句和循环时，我似乎没有发现问题。
请帮助了解在mysql过程中，准备好的语句是否不能在循环中工作。