【YashanDB 知识库】YAS-00218 string conversion failed.

DECLARE
    v_max_id NUMBER;
    v_min_id NUMBER;
    v_total_rows NUMBER;
    v_half_point NUMBER;
BEGIN
    SELECT MAX(REPORTTEMPLATEID), MIN(REPORTTEMPLATEID), COUNT(*) INTO v_max_id, v_min_id, v_total_rows FROM RPT_REPORTTEMPLATE_7NEW;
    v_half_point := CEIL((v_min_id+v_max_id) / 2.0); -- 计算应该插入的行数的一半（向上取整）
  
    -- 插入前一半数据
    INSERT INTO RPT_REPORTTEMPLATE_8NEW
        SELECT a.* FROM (
            SELECT * FROM RPT_REPORTTEMPLATE_7NEW WHERE REPORTTEMPLATEID <= v_half_point
        ) a ;
  
    COMMIT;
END;
/