Re: Question: SQL, XPath and several namespaces

From: Uwe M. Kuechler <gg.3.ukuechle_at_spamgourmet.com>
Date: 4 Aug 2006 01:36:49 -0700
Message-ID: <1154680609.011500.102550@h48g2000cwc.googlegroups.com>

Maxim Demenko wrote:

> This one works for me:
> SELECT extractvalue(request , '/*[local-name()=''PutOrderPurchaseIn'' and namespace-uri()=''http://www.mysite.de/schemas/putorderpurchasein/'']/CommonDataIn/endUserId','xmlns="http://www.mysite.de/schemas/commondatain/"')
> x
> FROM xml_tab
> WHERE trxid = 550000005559889;

Thanks a lot Maxim, this works for me, too. Whew, and I thought XML was supposed to make life easier... ;-)
And thanks for the hint regarding the OTN XML DB forum, I'll give it a try.

Best regards,
Uwe Received on Fri Aug 04 2006 - 03:36:49 CDT