while querying queue_table with payload of sys.xmltype, I get some Chinky data (see attachment)
same sql from 11.6, 12.7 works fine
while querying queue_table with payload of sys.xmltype, I get some Chinky data (see attachment)
same sql from 11.6, 12.7 works fine
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.