Re: xmltable and namespaces

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Thu, 03 Feb 2011 19:28:46 +0100
Message-ID: <4d4af3de$0$14262$ba620e4c_at_news.skynet.be>



declare
     soap_resp varchar(32767);
     resp      sys.xmltype;

begin

   soap_resp := '<GetStaffDetailsResponse xmlns="https://www.axby.com/staffQuery/">

   <GetStaffDetailsResult>

     <StaffDetails>

<AuEduPersonPreferredGivenName>Bruce</AuEduPersonPreferredGivenName>
<AuEduPersonPreferredSurname>Coad</AuEduPersonPreferredSurname>
<EmployeeID>000715BC</EmployeeID>
</StaffDetails>

   </GetStaffDetailsResult>
</GetStaffDetailsResponse>';

     resp := xmltype.createxml(soap_resp);

     for r in (
       select
         extractvalue(
           resp,
           '/GetStaffDetailsResponse/GetStaffDetailsResult/StaffDetails/EmployeeID',
           'xmlns="https://www.axby.com/staffQuery/"') X
         from dual
     ) loop
       dbms_output.put_line('Hello:' || r.X);
     end loop;

end;
/

Thanks to Flavio Casetta's "Annals of Oracle's Improbable Errors" : http://oraclequirks.blogspot.com/2008/05/oracles-xml-sql-functions-and-default.html Received on Thu Feb 03 2011 - 12:28:46 CST

Original text of this message