CRM中的一个函数，保存一下，别系统被ぅ崩坏就麻烦了.

CREATE OR REPLACE function UXQLCRM.GET_WEI_XIU(htfid in varchar2) 
return varchar is htleixingstr varchar2(5000);

CURSOR cr_bg_jl is 
    select "FServiceCon", 
            to_char("FInfReceiveTime",'yyyy/mm/dd')
    FROM "TuProductRepairment"
    WHERE "FLightOrderId"=htfid
            ORDER BY "FInfReceiveTime" DESC;

wxneirong varchar2(200);
wxshijian varchar2(36);
retchar varchar2(5000);
  
begin
  OPEN cr_bg_jl;
  LOOP 
  
    FETCH cr_bg_jl INTO wxneirong,wxshijian;
    EXIT WHEN  cr_bg_jl%NOTFOUND;
    retchar := retchar||wxshijian||wxneirong;
    
  END LOOP;
  CLOSE cr_bg_jl;
  return(retchar);
    
 END GET_WEI_XIU;
/