I am trying to display XMLTYPE in Oracle APEX.
Query:
select id,
xmlquery('declare default element namespace "http://www.omg.org/spec/BPMN/20100524/MODEL";
count(//definitions/process/task)'
passing xmltype(diagram)
returning content) as tasks
process_table
The Diagram column is clob.
Oracle APEX return [SYS.XMLTYPE] in the report for this column, but APEX SQL Commands return values correctly.
How to display the value in the report?
Vinish Kapoor
In SQL command, is it returning the multiple columns?
If yes, then you can add a parent query on this query and select the columns separately and then use this query for the report.