query result display issue 12.9.0.5

while querying queue_table with payload of sys.xmltype, I get some Chinky data (see attachment)

same sql from 11.6, 12.7 works finetoad_queue_table.png

Are you using the same Oracle client in 12.9 vs the others?

Yes, it’s the same home.

I see the same thing. For now, as a workaround, query your user_data column with GetClobVal, like this:

select x.q_name, x.msgid, ,

X.USER_DATA.GetClobVal() as USER_DATA

FROM JDORLON.XMLQTABLE X

You have to include the table alias for this to work (but it doesn’t have to be X).

This type of construct with XMLTYPEs is made automatically in the Schema Browser data tab.