ora-19025 extractvalue returns value of only one node
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?