oracle listagg乱码,oracle的listagg方法在使用时后台老警告

1.0.5版本报错，1.0.9版本该问题已解决。

2014-10-31 10:45:25,793 [http-bio-8080-exec-8] ERROR com.alibaba.druid.filter.stat.StatFilter - merge sql error, dbType oracle, sql :

select * from

( select a.*, rownum rn from

( select

cm.REPORT_ID, cm.TYPE_CODE, cm.REPORT_CODE, cm.REPORT_NAME, cm.OPERATOR_ID, cm.CREATE_TIME, cm.LAST_MODIFY_TIME,

cm.REPORT_STATUS,REPORT_TEMPLETE_NAME

,

(select LISTAGG(p.product_code,',')within group (order by p.report_id) from CM_APPLICATION_PRODUCT p where cm.report_id = p.report_id) product_codes,

(select LISTAGG(p.product_name,',')within group (order by p.report_id) from CM_APPLICATION_PRODUCT p where cm.report_id = p.report_id) product_names,

(select LISTAGG(ar.AREA_CODE,',') within group (order by ar.report_id) from CM_REPORT_AREA ar where cm.report_id = ar.report_id) area_codes,

(select LISTAGG(ar.AREA_NAME,',') within group (order by ar.report_id) from CM_REPORT_AREA ar where cm.report_id = ar.report_id) area_names,

t.type_name

from CM_REPORT cm ,CM_REPORT_TYPES t

where cm.type_code = t.type_code

order by product_codes,area_codes,cm.type_code ) a where rownum <= ? ) where rn > ?

com.alibaba.druid.sql.parser.ParserException: syntax error, expect BY, actual LPAREN group, pos 292