oracle查询返回1 2 3,oracle - 查询返回-> ORA-19011：字符串缓冲区太小 - 堆栈内存溢出...

我在下面运行此查询，并且oracle返回以下消息：查询返回-> ORA-19011：字符串缓冲区太小当我取消最后一行的注释时，它会起作用。 我认为这就是为什么这种返回很少的结果。 如何解决呢？

select substr(xmlagg(xmlelement (e, str||',')).extract ('//text()'),1,(Length(Trim(xmlagg (xmlelement (e, str||',')).extract ('//text()')))-2)) motivos

FROM (

select to_char(lo_valor) str

from editor_layout el,

editor_versao_documento ev,

editor_documento ed,

editor_layout_campo elc,

editor_campo ec,

editor_registro er,

editor_registro_campo erc,

pw_editor_clinico pec,

pw_documento_clinico pdc

where pec.cd_editor_registro = er.cd_registro

and pdc.cd_documento_clinico = pec.cd_documento_clinico

and ed.cd_documento = ev.cd_documento

and el.cd_versao_documento = ev.cd_versao_documento

and el.cd_layout = elc.cd_layout

and elc.cd_campo = ec.cd_campo

and elc.cd_campo = erc.cd_campo

and er.cd_registro = erc.cd_registro

and er.cd_layout = el.cd_layout

and ec.ds_identificador = 'nut_orientacoes_entregues_1'

AND To_Char(lo_valor) IS NOT null

--and Trunc(pdc.dh_documento) BETWEEN Trunc(SYSDATE-5) AND Trunc(SYSDATE)

)