ORA-22813 in XMLAGG

Hi all.

I wrote a SQL statement formatting some data in XML before transmitting to an external system. Oracle DB Server version is 19.6.0.0.0.

The basic xml structure is an envelope, containing multiple customers, each customer with multiple objects.

I can send quite large messages, hundreds of customers, but when the number of inner objects of the customer exceeds 20 or 30 items, ORA-22813 is raised.

If I break the inner structure at a given number of objects, creating two messages for the same customers, the entire dataset is processed with no error.

Unfortunately, I cannot use this workaround, due to limitation of receiving system.