8 Replies Latest reply: Dec 10, 2012 12:27 AM by Billy~Verreynne RSS

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

    978734
      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?