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!

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>

</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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2014

Added on Sep 14 2014

#performance-availability, #xml-db

2 comments

1,162 views