XMLDB - Remove Namespace Prefix using DBMS_XMLDOM

Hi,

We are using Oracle 11g (11.2.0.3) DB.

We have requirement to remove namespace and namespace prefix from XML document.

I could able to remove namespace from XML Document using DBMS_XMLDOM.SETATTRIBUTE (by setting attribute as NULL).   But not able to remove namespace prefix from XML doc. I tried with DBMS_XMLDOM.SETPREFIX, but it's not removing completely from XML Doc.

Could you please help me out.

Sample XML Doc:

<OrderList>

<abc:Order xmlns:abc="http://xyz.com">

  <id>123</id>

  <name>name1</name> 

</abc:Order>

<abc:Order xmlns:abc="http://xyz.com">

  <id>124</id>

  <name>name2</name> 

</abc:Order>

<abc: