Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

ora-19025 extractvalue returns value of only one node

edited Oct 31, 2019 5:00AM in Oracle Database Appliance (ODA) (MOSC) 1 commentAnswered

Hi,

I have the xml attached in table t_ws_xml and the sql:

SELECT extractValue(value(n), '//ordine/id/numeroOrdine/text()', 'xmlns="http://services.goodyear.it"') numeroOrdine

               ,extractValue(value(n), '//dettaglioOrdine/codiceArticolo[n]/text()','xmlns="http://services.goodyear.it"') codicearticolo

  FROM T_WS_XML a,

       table (xmlsequence(extract(a.xml_code, '//ordine', 'xmlns="http://services.goodyear.it"'))) n

WHERE extractValue(value(n), '//id/numeroOrdine/text()', 'xmlns="http://services.goodyear.it"') = '520'

I need to extract all the <codicearticolo> for each <numeroOrdine>, but the query return ora-19025.

Help me?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center