Hyperlink in BI Publisher + error ORA-01489: result of string concatenation is too long

Hi all,

I created an RTF layout and added a hyperlink to pass the parameters on to a drill down report.

The hyperlink is build using queries to pass all selected prompts.

My hyperlink ends by:

&_xmode=&_paramsBU={//BU}{//REG_LINK}{//DIST_LINK}{//SITE_LINK}&_paramsP_DATE1={//P_DATE1}&_paramsP_DATE2={//P_DATE2}&_xt=By_Store&_xf=pdf&_xautorun=false

The {//SITE_LINK} comes from a data set on the data model, the query ends like this :

WITH DT AS (...).....

SELECT LISTAGG('&'||'_paramsP_STORE='||(DT.SITE))WITHIN GROUP ( ORDER BY DT.SITE ) SITE_LINK FROM DT