tag:blogger.com,1999:blog-4677316190423110840.post8001620694811939461..comments2023-08-25T13:49:41.382+02:00Comments on Software Engineer Thoughts: XMLType and Namespace problemPaweł Baruthttp://www.blogger.com/profile/16867021334037413869noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4677316190423110840.post-50898959912858160032010-10-01T21:27:01.657+02:002010-10-01T21:27:01.657+02:00xml_ret := xml_ret.extract('//string/text()...<b>xml_ret := xml_ret.extract('//string/text()','xmlns="http://tempuri.org/"');<br /></b><br />this works <br /><br />but below statement doesn't<br /><b><br />xml_ret := xml_ret.extract('//string/text()');<br /></b>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-90811371020036666202007-03-09T15:41:00.000+01:002007-03-09T15:41:00.000+01:00i've solved it once using code like this: declare...i've solved it once using code like this:<BR/><I> declare<BR/> xml_str CLOB;<BR/> xml XMLType;<BR/> begin<BR/> ...<BR/> xml_str := xml.getCLOBval();<BR/> xml_str := regexp_replace(xml_str, 'xmlns:.*".*"', '');<BR/> xml_str := regexp_replace(xml_str, 'xsi:', '');<BR/> xml_str := regexp_replace(xml_str, 'ns[0-9]*:', '');<BR/> xml_str := regexp_replace(xml_str, 'soapenc:', '');<BR/> xml_str := regexp_replace(xml_str, 'soapenv:', '');<BR/> xml := xmltype(xml_str);<BR/> ...<BR/> end;</I><BR/>But, i'm not proud of this solution. If anybody knows more elegant solution, please let me know.Paweł Baruthttps://www.blogger.com/profile/16867021334037413869noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-62762345443193600342007-03-08T17:55:00.000+01:002007-03-08T17:55:00.000+01:00I ran into similar problems - getnamespace does no...I ran into similar problems - getnamespace does not seem to return a value (using 9i) <BR/><BR/>My biggest problem is that I get an XML from a WebService containing nodes with the default namespace "" ( e.g. <number xmlns="">12</number>) and it is not possible to extract this element.Anonymousnoreply@blogger.com