This discussion is archived
8 Replies Latest reply: Dec 9, 2012 10:27 PM by BillyVerreynne RSS

LISTAGG function: "result of string concatenation is too long"

978734 Newbie
Currently Being Moderated
Hello,

I'm using Oracle SQL developer version 3.0.04. I attempted to use the function LISTAGG to group the data together..
CREATE TABLE FINAL_LOG AS
SELECT SESSION_DT, C_IP, CS_USER_AGENT,
listagg(WEB_LINK, ' ')
     WITHIN GROUP(ORDER BY C_IP, CS_USER_AGENT) "WEB_LINKS"
     FROM webviews
     GROUP BY C_IP, CS_USER_AGENT, SESSION_DT
     ORDER BY SESSION_DT
However, I keep getting the error,

SQL Error: ORA-01489: result of string concatenation is too long

Is there any way to go around it or is there any other alternative?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points