Problems fecthing with xmltable using xmlnamespaces
Hi, I've the following XML save in a table in a XMLTYE field
<ORU_R01 xmlns="urn:hl7-org:v2xml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<MSH>
<MSH.1>|</MSH.1>
<MSH.7>
<TS.1>200804090000</TS.1>
</MSH.7>
</MSH>
</ORU_RO1>
When I've tried to retrive it using the SQL statment below, it doesn't fetch any record
select m.*
from HA.Hl7_Messages h,
xmlTable
( XmlNamespaces('urn:hl7-org:v2xml' AS xmlns),
'/ORU_R01'
passing h.msg
Columns
CA VARCHAR2(10) Path 'MSH/MSH.1',
CB VARCHAR2(30) Path 'MSH/MSH.7/TS.1',
) m
I used xmlTable WITHOUT namespaces and works fine, but here I think that is a namespace problem. I've tried adding the namespace (eg,/xmlns:ORU_RO1) in different ways but nothings happens.
Any idea?