Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

Post Details

Added on Dec 29 2022
#performance-availability, #xml-db
2 comments
445 views