Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
There might be still an issue when displaying xmltype is SqlDeveloper 18.3:
For example, execute the following query:
select xmlforest(first_name, last_name, email)
and then double click in a cell of data grid.
Sometimes it shows data in xml format, and sometimes it
displays ORA-22275: invalid LOB locator specified.