title: ORA-01489: result of string concatenation is too long 01489. 00000 - "result of string concatenation is too long"
body: <p>I have this query but I got an  ORA-01489 Error : ORA-01489: result of string concatenation is too long 01489. 00000 -  "result of string concatenation is too long", Is it posible resolve this problem maybe setting a system variable ?</p>
  
  <pre><code>SELECT "USER_PRIMARY_sector","LOGIN","FIRST_NAME","LAST_NAME","sector_ROLE"
  FROM (
  SELECT user_primary_sector,login, first_name,  last_name,
         LTRIM(MAX(SYS_CONNECT_BY_PATH(rights,' / '))
         KEEP (DENSE_RANK LAST ORDER BY curr),' / ') AS sector_ROLE
        FROM  
          (SELECT  login,
                first_name,  
                last_name,
                user_primary_sector,
                rights,
                ROW_NUMBER() OVER (PARTITION BY login ORDER BY rights) AS curr,
                ROW_NUMBER() OVER (PARTITION BY login ORDER BY rights) -1 AS prev
          FROM  (select   member0_.login,  member0_.first_name first_name, sector2.sector_name user_primary_sector,  member0_.last_name last_name,
                          CONCAT(CONCAT(sector.sector_name, ' - '), role3_.role_name) rights 
   from
    TLC_DEVICES.t_member member0_
   inner join  TLC_DEVICES.t_user member0_1_    on member0_.member_id=member0_1_.user_id
   inner join  TLC_DEVICES.t_playable_role playedrole1_    on member0_.member_id=playedrole1_.user_id
   inner join  TLC_DEVICES.t_sector_role sectorrole2_    on playedrole1_.sector_role_id=sectorrole2_.sector_role_id
   inner join  TLC_DEVICES.t_role role3_    on sectorrole2_.role_id=role3_.role_id
   inner join  TLC_DEVICES.t_sector sector    on sectorrole2_.sector_id=sector.sector_id
   inner join  TLC_DEVICES.t_sector sector2    on sector2.sector_id=member0_1_.primary_sector_id
   where    current_date between playedrole1_.start_date and playedrole1_.end_date
   order by sector.sector_name
    ))
  GROUP BY login, first_name,  last_name, user_primary_sector
  CONNECT BY prev = PRIOR curr AND login = PRIOR login
  START WITH curr = 1
  )
  ORDER BY user_PRIMARY_sector, FIRST_NAME, LAST_NAME;
  </code></pre>