Help ! Extract data from XML result in PL/SQL [message #348878] |
Thu, 18 September 2008 03:43 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
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
|
|
|