Displaying XMLTYPE

[bobski1]

I have the query below which returns an XMLtype when I run it all I get is black square in the SQL window.I could of course convert to CLOB but when can I expect it to be displayed in PL/SQL developer.

SELECT XMLElement("Station",
XMLAttributes(ss.station_name AS "Name"),
XMLAgg(
XMLElement("Sales_Channel",
XMLForest(sc.channel_name AS "Name",
sc.sales_channel_id AS "sales_channel_id"))))
FROM sales_station ss INNER JOIN sales_channel sc
ON sc.sales_station_id = sc.sales_station_id
GROUP BY ss.station_name

 

[Marco Kalter]

You will indeed need to use the getclobval() function in this situation. Oracle Net 9.0 and earlier did not support the SYS.XMLTYPE object type (it would crash) and therefore PL/SQL Developer avoids it. Oracle Net 9.2 does support it though, and a future (patch) release will take advantage of this.

Right now you need to use getclobval() though.

------------------
Marco Kalter
Allround Automations