RE: valid node xmlparser oracle 10g
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <mark-clist@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Nov 2009 08:13:45 -0500
Thanks for the reply. A piece of the xml looks like this, looking at the
documentation, it looks like you can add the namespaces to the extract or
extractvalue but I couldn't get it to work, kept getting errors. I think
I'll fire up an 11G db and see what I can work with. It looks like extract
and extractvalue are deprecated in 11G. This xml is just a fragment the
whole xml is 126K.
<n1:submit xmlns:n1 = "ca/joe/test/autotype/submitrequest" xmlns:xsi =
"http://www.w3.org/2001/XMLSchema-instance";>
<requestHeader xmlns = "ca/joe/test/autotype/submitrequest">
<ns1:customerInteractionType xmlns:ns1 =
"ca/joe/test/autotype/testcommonrequest">ContactCentre</ns1:customerInteract
ionType>
<ns2:serviceRequestUserId xmlns:ns2 =
"ca/joe/test/autotype/testcommonrequest">N296922</ns2:serviceRequestUserId>
<ns3:serviceConsumer xmlns:ns3 =
"ca/joe/test/autotype/testcommonrequest">Odorrmax</ns3:serviceConsumer>
<ns4:serviceRequestTimestamp xmlns:ns4 =
"ca/joe/test/autotype/testcommonrequest">2009-10-29T16:13:26.524-04:00</ns4:
serviceRequestTimestamp>
<ns5:language xmlns:ns5 =
"ca/joe/test/autotype/testcommonrequest">English</ns5:language>
<ns6:referenceID xmlns:ns6 =
"ca/joe/test/autotype/testcommonrequest">A26P83Z3</ns6:referenceID>
</requestHeader>
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mark Weaver
Sent: Monday, November 02, 2009 8:35 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: valid node xmlparser oracle 10g
On 02/11/2009 4:57 PM, Michael McMullen wrote:
> Does anyone know offhand if nodes like "n1:submit" is valid in xml. All
> of our xml is changing that we parse to run reports on and our tests are
> saying
>
yes, they are valid -- they are called namespaces. There should be an
xmlns attribute (usually at the start of the document, but it can be for
individual elements), that declares the namespace, see:
http://www.w3.org/TR/REC-xml-names/
for the gory details. It might be simply that you are missing the
namespace declaration -- you can usually provide these externally to
parsers which is what the app that generates the data might be doing.
I've not checked that namespaces actually work with Oracle's xml parser,
but I would think that they would as they are pretty fundamental.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
