XQuery fails with ORA-19276: XPST0005 - XPath step specifies an invalid element/attribute name
(Doc ID 1949456.1)
Last updated on NOVEMBER 28, 2014
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation in this document applies to any platform.
Symptoms
XQuery with nested square brackets "[" fails in versions > 11.2.0.2:
SQL> SELECT XMLQuery('
2 string-join(
3 for $name as attribute()
4 in $itmCntntXml/((item|set_leader)/(item_information/@item_name|item_content/item_part/@part_name)|/item[item_information[string(@item_name)="Interactive"]]//interactive_with_response/interactive_file/@external_file_name)
5 return string($name),
6 "__IBIS_DELIMITER__"
7 )
8 ' PASSING io.itm_cntnt_xml AS "itmCntntXml" RETURNING CONTENT).getStringVal() AS my_xml
9 FROM itm_obj io;
FROM itm_obj io
*
ERROR at line 9:
ORA-19276: XPST0005 - XPath step specifies an invalid element/attribute name:(item_name)
2 string-join(
3 for $name as attribute()
4 in $itmCntntXml/((item|set_leader)/(item_information/@item_name|item_content/item_part/@part_name)|/item[item_information[string(@item_name)="Interactive"]]//interactive_with_response/interactive_file/@external_file_name)
5 return string($name),
6 "__IBIS_DELIMITER__"
7 )
8 ' PASSING io.itm_cntnt_xml AS "itmCntntXml" RETURNING CONTENT).getStringVal() AS my_xml
9 FROM itm_obj io;
FROM itm_obj io
*
ERROR at line 9:
ORA-19276: XPST0005 - XPath step specifies an invalid element/attribute name:(item_name)
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 |
| Cause |
| Solution |
| References |
| This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |