XML Query Returns ORA-19279 on 11.2.0.1, 11.2.0.2 but Not on 11.1.0.7 (Doc ID 1373311.1)

Last updated on NOVEMBER 03, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

A XML query executed on 11.2.0.1/2 returns error

ORA-19279: XPTY0004 - XQUERY DYNAMICTYPE MISMATCH: EXPECTED SINGLETON SEQUENCE - GOT MULTI-ITEM SEQUENCE

while it was running fine on 11.1.0.7.

SELECT TR954_INT_OUT.C_CMP_SRG_IV
 FROM
 (SELECT XMLTYPE(LOBREQRESULT) XML
 FROM xmltest.w_SLEREQRESULTS
 )SLEREQRESULTS
 ,
 XMLTABLE (
 '/'
 PASSING XML
 COLUMNS
 XML_1 XMLTYPE PATH '/Sprint_01XT4_MsgResp') TR953_RDC_INT_OUT,
 XMLTABLE (
 'Sprint_01XT4_MsgResp'
 PASSING XML_1
 COLUMNS
 C_CMP_SRG_IV VARCHAR2(3200) PATH 'PDets/Eu/IV/@CSA') TR954_INT_OUT;
/

returns
ORA-19279: XPTY0004 - XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms