Skip to Main Content
Forums

DevOps, CI/CD and Automation

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.

Extract value from XML

Andrew ROct 2 2007 — edited Nov 9 2007
Hi,

Given the following XML:

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ConversionRateResponse xmlns="http://www.webserviceX.NET/">
<ConversionRateResult>double</ConversionRateResult>
</ConversionRateResponse>
</soap:Body>
</soap:Envelope>

How do I extract the ConversionRateResult value using plsql? I'm not sure what XPath value to use. I've tried variations on

l_rate := respXML.extract('ConversionRateResult/text()', '"http://www.webserviceX.NET/"').getstringval();

but i get an "ORA-31013: Invalid XPATH expression" error.

Any help would be appreciated.

Thank you,

Andrew.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 7 2007
Added on Oct 2 2007
#pl-sql-xml-programming, #xml
2 comments
3,941 views