Estou com o seguinte problema pessoal, estou executando o código:
SELECT PP_CODIGO,
LTRIM (MAX (SYS_CONNECT_BY_PATH (EQ_TAG, ', ')), ',')
EQ_TAGS
FROM (SELECT PP_CODIGO,
PP.EQ_CODIGO,
EQ.EQ_TAG,
ROW_NUMBER ()
OVER (PARTITION BY PP.PP_CODIGO
ORDER BY PP.EQ_CODIGO)
rn
FROM WEBUJU.SAMI_PREVENTIVA_EQUIPAMENTO PP,
WEBUJU.SAMI_EQUIPAMENTO EQ
WHERE PP.EQ_CODIGO = EQ.EQ_CODIGO)
CONNECT BY PP_CODIGO = PRIOR PP_CODIGO AND rn = PRIOR rn + 1
START WITH rn = 1
GROUP BY PP_CODIGO
ORA-01489: result of string concatenation is too long
Abraço.