I need to read the namespace xml saved as an IFS file.
I try
for file
<xmlroot xmlns="http://definition/">
....
</xmlroot>
but SQL returns NULL
Do you have idea how should I do it?
I try
Code:
select xmldta.* from xmltable ('/' passing xmlparse(document get_xml_file(/tmp/my.xml')) columns ns varchar(512) path 'xmlroot/@xmlns') xmldta
<xmlroot xmlns="http://definition/">
....
</xmlroot>
but SQL returns NULL
Do you have idea how should I do it?
Comment