Hi,
i have this select to read xml data:
select *
from xmltable(
xmlnamespaces(
default 'http://soap.mareon.com/hwa24/schema',
'http://schemas.xmlsoap.org/soap/envelope/' as "soap"
),
'/soap:Envelope/soap:Body/soap:Fault'
passing xmltype('<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header></soap:Header><soap:Body><soap:Fault><faultcode>soap:Client</faultcode><faultstring>ORDER_SET_STATE_FAILED_WRONG_STATE</faultstring><detail><genericFault xmlns="http://soap.mareon.com/hwa24/schema"><err>205</err><errtext xml:lang="de">Änderung des Auftragsstatus fehlgeschlagen. "E" ist ein ungültiger Status! Gültige Werte: CANCELED,ACCEPTED,PARKED,SEEN,DONE,CONDITIONALACCEPTANCE</errtext><time>2024-05-01T08:56:07</time></genericFault></detail></soap:Fault></soap:Body></soap:Envelope>')
columns
faultcode varchar2(100) path 'faultcode',
faultstring varchar2(1000) path 'faultstring',
err varchar2(100) path 'detail/genericFault/err',
errtext clob path 'detail/genericFault/errtext')
But the result is one line with null values.
Any hints ?