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
<ProductID> '1' </ProductID>
<Productname> 'ABC' </Productname>
But the XML data is stored in table as
<C:ProductID> '1' </C:ProductID>
<C:Productname> 'ABC' </C:Productname>
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?