Database Software

I am trying to use extractvalue function on a XML document that uses multiple namespaces. So my XPath expression is something like '/coresalesorder:CreateSalesOrder/corecom:Identification/corecom:ID' . Please note that the expression uses two namespaces.

In this case, how do I specify these two namespaces in the extractvalue function ? I tried something like,

select extractvalue(a.source_order,'/coresalesorder:CreateSalesOrder/corecom:Identification/corecom:ID','xmlns:corecom="http://xmlns.oracle.com/EnterpriseObjects/Core/Common/V2",xmlns:coresalesorder="http://xmlns.oracle.com/EnterpriseObjects/Core/EBO/SalesOrder/V2"')
from source_order a

But this doesn't work. Any help/pointers will be very much appreciated.

Thanks.