My Oracle Support Banner

Extract Function Returns ORA-19025 after DELETEXML Command (Doc ID 1440390.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms


Following error is generated:

ERROR:
ORA-19025: EXTRACTVALUE returns value of only one node

When try to select the content of a row after performed a deleteXML command on a node from within the XML content. For example, create table of OF XMLType and insert following data into it:
<product_details id="1"><product
id="21"><name>test1</name><code>123</code></product><product
id="20"><name>test2</name><code>456</code></product></product_details>

then delete the product node with id = 21 from the XML content.

select with extract now produces the following error:
SELECT extract(OBJECT_VALUE, '/product_details[@id=1]') "Xml" FROM test WHERE
XMLEXISTS('/product_details[@id=1]' PASSING OBJECT_VALUE);

ERROR:
ORA-19025: EXTRACTVALUE returns value of only one node

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.