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.

can not extract value from xmltype

dashandwerk.netSep 14 2014 — edited Sep 15 2014

Hello helpers,

i have a webservice which sends this xml into a table column with type xmltype

table = tmp_data

column = xml_data

<?xml version="1.0" encoding="WINDOWS-1252"?>

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <soap:Body>

    <calculateIBAN2Response xmlns="http://tempuri.org/">

      <calculateIBAN2Result>IBAN DE09 5003 3300 0123 4567 89</calculateIBAN2Result>

    </calculateIBAN2Response>

  </soap:Body>

</soap:Envelope>

After retrieving this xml i want to extract the value for the result, but it is not working.

Here is the query:

select extractvalue(xml_data,'/soap:Envelope/soap:Body/calculateIBAN2Response/calculateIBAN2Result') from tmp_data

After executing this simple select o get this error:

ORA-31013: Ungültiger XPATH-Ausdruck

31013. 00000 -  "Invalid XPATH expression"

*Cause:    XPATH expression passed to the function is invalid.

*Action:   Check the xpath expression for possible syntax errors.

Fehler in Zeile: 21 Spalte: 107

I have checked this xml with a xml viewer and it says no errors.

The xml checker shows the xpath in the same way.

But what is wrong ?

Thank you for help.

Regards

Frank

Comments

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

Post Details

Locked on Oct 13 2014
Added on Sep 14 2014
#performance-availability, #xml-db
2 comments
1,150 views