oracle - for in loop 查询某张表的数据，拼接成字符串

FUNCTION FUN_GET_ELEINVOICEINFO
(
FS_INVOICESEQ in varchar2,
) RETURN NUMBER is

ls_paymode      clob;

begin

for paymode in (select *
from view_ele_paymode
where BUSNO=FS_INVOICESEQ)
loop

if ls_paymode is null then
ls_paymode:= '{'||'"payChannelCode":"'||paymode.payChannelCode||
'","payChannelValue":"'||paymode.payChannelValue||'"}';
else
Dbms_Lob.append(ls_paymode,',{'||'"payChannelCode":"'||paymode.payChannelCode||
'","payChannelValue":"'||paymode.payChannelValue||'"}');
end if;
end loop;

return 0;

end FUN_GET_ELEINVOICEINFO;