mysql第一个存储过程

DROP PROCEDURE IF EXISTS testEndHandle;

CREATE PROCEDURE testEndHandle()
BEGIN
 DECLARE tmp_region VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 DECLARE s int DEFAULT 0;
  DECLARE t_index CURSOR FOR SELECT proposalno from policy_main ;
    DECLARE CONTINUE HANDLER FOR not FOUND SET s=1;
    OPEN t_index;
REPEAT

        FETCH t_index INTO tmp_region;
    if not s THEN 
                 insert into policyinfo select 
    pm.bxdh bxdh,
    pm.bxgsdm bxgsdm,
    pm.bxgs  bxgs,
    pc.hpzl hpzl,
    pc.hphm  hphm,
    pc. clsbdh clsbdh,
    pm.sxrq  sxrq,
    pm.zzrq zzrq,
    pd.bbxr bbxr,
    pd.bbxrsfzmhm bbxrsfzmhm,
    '1' jqxtbzt,
    ta.ccsnsqk ccsnsqk,
    ta.ccsnsje ccsnsje,
    ta.wspzhm wspzhm,
    ta.nsrsbh nsrsbh,
    null ccsnsrq ,
    ta.ccsnsqsrq ccsnsqsrq,
    ta.ccsnszzrq ccsnszzrq,
    ta.nsr nsr,
    '1'  yxbz,
    '0' errorcounts,
    '1' status,
    pm.proposalNo  proposalNo

    FROM ( SELECT * FROM policy_main WHERE ProposalNo =tmp_region 
 LIMIT 1 ) pm,
    ( SELECT * FROM prpccar_ship_tax WHERE ProposalNo = tmp_region  LIMIT 1 ) ta,
    ( SELECT * FROM prpcitem_car WHERE ProposalNo = tmp_region  LIMIT 1 ) pc,
    ( SELECT * FROM prpcinsured WHERE ProposalNo = tmp_region  LIMIT 1 ) pd;
    
    end if;
UNTIL s END REPEAT;
 CLOSE t_index;
 
END;
  
call testEndHandle;