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.
Answer / 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 |
What are the advantages of SOAP?
Explain about the syntax rules in SOAP?
How is SOAP different from the Ariba and Commerce One Standards of cXML etc?
Explain about the SOAP body element?
Explain what is the properties in soapui?
What does xml-soap server includes to allow flexible services for the users?
explain how you can parameterize the endpoints in soap ui?
What is soap protocol used for?
Explain about the encoding style attribute?
What is the major obstacle users faced when using soap?
To test a web service you must create a windows application or web application to consume this service. State whether true or false.
What are the factors that help to decide which style of web services – soap or rest – to use?