Kalyana, September 24, 2021 - 10:17 am UTC
Hi,
If the namespace is below the root, for.e.g you have in more than one place below the root, is it possible to use the above sample code?
If not , can we know the steps?
Thanks in advance,
Regards
Kalyanaa
September 24, 2021 - 4:07 pm UTC
You can have multiple namepsaces - what exactly is it you're trying to do? Give us an example!
removing namespaces from large xml
Kalyana, September 25, 2021 - 7:15 am UTC
Hi,
I am attaching the xml file which has multiple namespaces.
There are namespaces even below the root element.
Could you suggest a way to remove all the namespaces including the root element and below.
Regards
Kalyana
----------------------------------------------------------------------------
<?xml version ="1.0"?>
<MTMROOT xmlns="
http://www.mtg.com/ILSENET/Interface" >
<MTMDATA>
<MTMFileupload xmlns:xsl="
http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
http://ww.w3.org/2001/XMLSchema" >
<StartDate>2021-05-28T01:06:51.8576073-04:00</StartDate>
<sid>2c08b76-bbe-9f32-936cbf958779</sid>
<DGroups>1200</DGroups>
<NumRecords>10</NumRecords>
<LineDetails>
<LineDetail> <UserAttr1>ABC</UserAttr1>
<UserAttr2>DEG</UserAttr2>
<UserAttr3>MIS</UserAttr3>
<UserAttr4>VRL</UserAttr4>
</LineDetail>
</LineDetails>
</MTMFileupload>
</MTMDATA>
</MTMROOT>
--------------------------------------------------------------------
removing namespaces from large xml
Kalyana, September 27, 2021 - 1:40 pm UTC
Hi Team,
Is the given info sufficient?
Do you require more info?
The above operation needs to performed on Oracle 11g database.
Regards
Kalyana
Kalyana, September 28, 2021 - 1:39 pm UTC
Hello Team,
Greetings!!!
I have posted the required xml file.
Is the information sufficient?
I am not able to ask questions through the main page.
Hence I am writing here.
Requesting an update for the query.
Regards
Kalyana