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
begin
</GetStaffDetailsResult>
</GetStaffDetailsResponse>';
end;
/
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