1 2 Previous Next 21 Replies Latest reply: Mar 27, 2013 10:47 PM by user12136582 RSS

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

      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
      Seqno" FOR ORDINALITY,
      "ScarsMarksTattoos" varchar(30) PATH 'ScarsMarksTattoos'
      ) AS X;
      ORA-19279: XQuery dynamic type mismatch: expected singleton sequence - got
      multi-item sequence
      ---------------------------- XML DATA that was loaded into an XMLTYPE table -----------
      - <IdSegment>
      <ScarsMarksTattoos>TAT L LEG</ScarsMarksTattoos>
      <ScarsMarksTattoos>SC BREAST</ScarsMarksTattoos>
      <ScarsMarksTattoos>SC ABDOM</ScarsMarksTattoos>
        1 2 Previous Next