Re: xmltable and namespaces
From: Gerard H. Pille <ghpille_at_hotmail.com>
Date: Fri, 4 Feb 2011 01:43:40 -0800 (PST)
Message-ID: <cce8334b-aef8-4b51-aeb3-ff12dc978205_at_k22g2000yqh.googlegroups.com>
declare
soap_resp varchar(32767);
resp sys.xmltype;
begin
soap_resp :=
'<GetStaffDetailsResponse'
|| '</GetStaffDetailsResult>'
|| '</GetStaffDetailsResponse>';
) loop
dbms_output.put_line('Hello:' || r.X); end loop;
end;
/ Received on Fri Feb 04 2011 - 03:43:40 CST
Date: Fri, 4 Feb 2011 01:43:40 -0800 (PST)
Message-ID: <cce8334b-aef8-4b51-aeb3-ff12dc978205_at_k22g2000yqh.googlegroups.com>
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>' || '<StaffDetails>'
|| '<AuEduPersonPreferredGivenName>Lazy</
AuEduPersonPreferredGivenName>'
|| '<AuEduPersonPreferredSurname>Richard</
AuEduPersonPreferredSurname>'
|| '<EmployeeID>000999ZZ</EmployeeID>'
|| '</StaffDetails>'
|| '</GetStaffDetailsResult>'
|| '</GetStaffDetailsResponse>';
resp := xmltype.createxml(soap_resp);
for r in (
select
extractvalue( value(Y), '/StaffDetails/EmployeeID', 'xmlns="https://www.axby.com/staffQuery/"') X from table( xmlsequence( extract( resp, '/GetStaffDetailsResponse/GetStaffDetailsResult/ StaffDetails', 'xmlns="https://www.axby.com/staffQuery/"' ) ) ) Y
) loop
dbms_output.put_line('Hello:' || r.X); end loop;
end;
/ Received on Fri Feb 04 2011 - 03:43:40 CST