User defined aggregate functions in PIVOT

[yuriynv]

Hello

I've implemented an user defined aggregate function that concates strings as suggested here http://www.oracle-base.com/articles/mis ... niques.php.

This function works fine in ordinary SELECTs

select name,stragg(text_value)
from d_run_attr
where run_id in (19586660,19650792)
group by name

but whenever I use it in PIVOT clause

SELECT *
FROM (select a.name,
a.text_value
from d_run_attr a)
PIVOT (STRAGG(b.text_value)
FOR (name) IN ('STATUS','WORKLISTNAME') )

I always get
Error report:
SQL Error: ORA-56902: expect aggregate function inside pivot operation

Could anyone help me and explain what's wrong?

Best regards, Yury

[Tim...]

Hi.

Maybe PIVOT doesn't support user-defined aggregate functions. If you are using 11gR2, you can try LISTAGG. If not, then I suggest you contact Oracle Support for confirmation.

Cheers

Tim...