This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Mar 27, 2013 8:47 PM by user12136582 RSS

ORA-19279: XQuery dynamic type mismatch:expected singleton sequence-multi-

503668 Newbie
Currently Being Moderated
Hello
We have some XML data files with some recurring elements in them, we are trying to pull them from an XMLTYPE table using the code below.
-------------------------------------------------

SELECT X.*
FROM TMP_XML P2,
XMLTable ( '//P//IdSegment'
PASSING P2.object_value
COLUMNS
Seqno" FOR ORDINALITY,
"ScarsMarksTattoos" varchar(30) PATH 'ScarsMarksTattoos'
) AS X;
-------------------------------
ERROR:
ORA-19279: XQuery dynamic type mismatch: expected singleton sequence - got
multi-item sequence
---------------------------- XML DATA that was loaded into an XMLTYPE table -----------
<P>
- <IdSegment>
<ScarsMarksTattoos>TAT L LEG</ScarsMarksTattoos>
<ScarsMarksTattoos>SC BREAST</ScarsMarksTattoos>
<ScarsMarksTattoos>SC ABDOM</ScarsMarksTattoos>
</IdSegment>
</P>
1 2 Previous Next