ORA-29400, ORA-22813 Raised in an XML Query Having a Concatenation of FN:COLLECTION (Doc ID 1587780.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

A query containing a concatenation of collections like

SELECT        XmlType.getClobVal(COLUMN_VALUE)
    FROM XMLTABLE(' (:INIT LOCAL FUNCTION DECLARATION:)(:END LOCAL FUNCTION DECLARATION:) count((
     let $queryValue:=(:pagination:)(collection("oradb:/BASVI/REGRESS_29_ALF/ROW[( LASTREVISION=''S'')]/VALUE"),
     collection("oradb:/BASVI/REGRESS_29_ALF/ROW[(LASTREVISION=''N'' )]/VALUE"))/element()[1]
    for $input at $i in $queryValue
    let $xml:=$input/xmlValue/RMO_ORACLE
    return <value>
    <xmlValue >
    {$xml/*}
    </xmlValue>
    </value>
    )
    )') tmp;

may raise errors
ORA-29400: data cartridge error
ORA-22813: operand value exceeds system limits

The error reproduces only when a big amount of data is involved in the query

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