Define XSD with namespace the match expected XML output

using extract_from_xml function to process an XML file saved as CLOB in oracle database table.

Based on the XSD's i was provided the Elements are mapped as

<Extract>

<Product>

<ProductID> '1' </ProductID>

<Productname> 'ABC' </Productname>

</Product>

<Customer>

<Customerid>'200' </Customerid>

<Customername>'Jack' </Customername>

</Customer>

</Extract>

But the XML data is stored in table as

<A:Extract>

<B:Product>

<C:ProductID> '1' </C:ProductID>

<C:Productname> 'ABC' </C:Productname>

</B:Product>

<B:Customer>

<C:Customerid>'200' </C:Customerid>

<C:Customername>'Jack' </C:Customername>

</B:Customer>

</A:Extract>

When trying to validate the function it gives the following error:

NRDM Function <Cannot parse expression.LONG or BLOB column <XML_DATA> cannot be used as a parameter of functions.. (BODI-1112351)> (BODI-1111191)

Any suggestion on how to go about generating an XSD that would be in sync with the additional text thats getting added infront of the Elment names? I have no clue how to go about doing this?

Regards,

islauddin