| Help ! Extract data from XML result in PL/SQL [message #348878] |
Thu, 18 September 2008 03:43  |
suraj_an
Messages: 15
Registered: February 2008
|
Junior Member |
|
|
Hi
I need some help urgently on how to extract the result (which is
'helloTestingConcat' from the following XML. I am getting the following result from a web service and I need to extract the result of the web service from the XML. How do I do it?
The below code is not working.
declare
v_lob clob;
v_xml xmltype;
v_ret_val varchar2(1000);
begin
v_lob := '<env:Envelopexmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header/><env:Body><Simple_test1ProcessResponse xmlns="http://xmlns.oracle.com/Simple_test1">
<result xmlns="http://xmlns.oracle.com/Simple_test1">helloTestingConcat</result>
</Simple_test1ProcessResponse></env:Body></env:Envelope>';
v_xml := xmltype(v_lob);
dbms_lob.freetemporary(v_lob);
-- extractvalue needs to be used in select statement
select extractvalue(v_xml,'//Envelope/Body/Simple_test1ProcessResponse/result') into v_ret_val from dual;
dbms_output.put_line('Value is'||v_ret_val);
end;
Thanks
|
|
|
|
| Re: Help ! Extract data from XML result in PL/SQL [message #348889 is a reply to message #348878] |
Thu, 18 September 2008 04:07  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).
What does "is not working" mean? What is the expected result?
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
