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-

    503668
      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