declare cursor c_py is
SELECT int_File from tb_Ms_LeaveWord
where ti_NewFlag = 0 and vc_Called = inPhone and vc_Calling =tmpCalling and vc_RegionCode = RegionCode
order by dt_CreateTime desc;
begin
for r in c_py loop
tmpRecord:=tmpRecord||','||r.int_File;
end loop;
end;
SELECT int_File from tb_Ms_LeaveWord
where ti_NewFlag = 0 and vc_Called = inPhone and vc_Calling =tmpCalling and vc_RegionCode = RegionCode
order by dt_CreateTime desc;
begin
for r in c_py loop
tmpRecord:=tmpRecord||','||r.int_File;
end loop;
end;