SAS/ACCESS Interface to Oracle does not support reading of Oracle data type SYS.XML. To work around this, use the Oracle function EXTRACT to extract the XML data of your choice.

Here is an example pertaining to duplicate data items:

Select Field1 ExtractValue(value(xml_field),'/xml_field', 'xmlns=http://www.xxx.sas.com/xmldemo/1.0#xmldemo">http://www.xxx.sas.com/xmldemo/1.0#xmldemo') as Extracted_XML From xmldemo.XMLDEMO_TBL xmltbl, table(xmlsequence(Extract(xmltbl.XML_Field,'xmllev1/xmllev2/xmlfield', 'xmlns=http://www.xxx.sas.com/xmldemo/1.0#xmldemo">http://www.xxx.sas.com/xmldemo/1.0#xmldemo'))) xml_field