Interested to Buy Any Domain ? << Click Here >> for more details...
soapui
<person>
<fname>abc</fname>
<lname>xyz</lname>
<age>22</age>
</person>
above data i am prepareing in soapui and run the request and
generate response.
how to fetch this xml response data using oracle sql query.
pls tell me query.
- 1 Answers
- 2166 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / Vikram Singh Vimal
To fetch XML response data from an Oracle database, you can use the DBMS_XMLGEN package. Here's a sample code snippet:
DECLARE
v_xml XMLType;
l_response CLOB;
BEGIN
SELECT xmltype(l_response) INTO v_xml
FROM table_name
WHERE some_condition = 'some_value';
DBMS_OUTPUT.PUT_LINE(v_xml);
END;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
