| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| Hi, I am trying xml data processing using Xquery version 9.1 My xml file --------- HTML Code: <?xml version="1.0" ?> <S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"> <S:Body> <GetBookingDetailsResponse xmlns="http://types.xml.bookingquery.myproject.ws.clientname.com"> <record> <id>123</id> </record> To get id value i.e 123 fallowing query will work if I remove above name spaces in xml file select XMLCAST(xmlquery('$id/record/id' passing info as "id"), name AS VARCHAR(25)) from src_tab but according to my requirement I cant remove that xmlns from xml. So please tell me how to handle names spaces in xquery. Can I have example query for above situation. Appreciate for early replies. Thanks and regards tomasss |
![]() |
| Thread Tools | |
| Display Modes | |