When executing the statement below in a SQL window the developer just hangs and must be killed from Windows task manager.
SELECT xmlelement("item_txt", item_txt)
FROM item;
By converting the XMLTYPE to a string data is returned as expected
SELECT xmlelement("item_txt"...