DevOps, CI/CD and Automation

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: '/*/name()'

Oracle 10.2.

I am unable to resolve an issue while trying to show an element name. I would like it to show the element name for all of the child nodes under callEventDetails. I would post some XML, but the file is a monster. I am hoping this is just a case of my lack of XML knowledge in Oracle, and that someone will have a quick answer.

I have simplified the query to what is below, and still the same error. I have tried several things as the PATH for "TYPE" including name(.).


SELECT X.*
FROM tapxml_tbl P2,
XMLTable
(
'/DataInterChange/transferBatch/callEventDetails/*'
PASSING P2.object_value
COLUMNS
"TYPE" varchar(30) PATH 'name()'
) AS X;