'How to read the data from column of type APPS.WF_PARAMETER_LIST_T using SQL Query in Oracle

I have a requirement to read the data from column of type APPS.WF_PARAMETER_LIST_T in Oracle.

I am getting SQL Error [904] [42000]: ORA-00904: "T"."EVENT_VALUE"."PARAMETER_LIST"."NAME": invalid identifier error when reading the data as

SELECT t.EVENT_VALUE.PARAMETER_LIST.NAME,
t.EVENT_VALUE.PARAMETER_LIST.VALUE FROM
APPLSYS.WF_ITEM_ATTRIBUTE_VALUES t;

Please help.

oracle

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source