Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XMLtype How to extract the url from envelope

HoekDec 29 2022

Hi all, it's been more than 10 years ago since I had to work with XML data and I'm kind of 'rusty' in that matter.
Oracle database 19cEE
This is the response I get using apex_web_service.make_request, it's in an XMLtype variable:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <ns2:actionResponse xmlns:ns2="http://xmlns.bla.nl/showAction/showAction">
      <url>http://dev-env.bla.intern/runtime/server/StartSession?startToken=bb814c4d-2a65-434a-a270-6a122cf52ee6</url>
    </ns2:actionResponse>
  </soap:Body>
</soap:Envelope>

Is there a way to extract the url only? I thought this would be an easy one, but I just don't see it. Any hint of pointer will be much appreciated. Many thanks in advance for your help!
Regards,
Hoek

This post has been answered by cormaco on Dec 30 2022

Jump to Answer

Added on Dec 29 2022

#performance-availability, #xml-db

2 comments

515 views