Error With A XML Output
(Doc ID 2257693.1)
Last updated on MARCH 10, 2020
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
We have a problem with a registered script in SQL.
In the script (R code) we manipulate tables, creating a XML with them and we return that XML in "clob" format, and when we look the result we see that:
- If we call the registered script with code R the output is correct
- If we call the registered script with SQL code, on line 2000 of XML output, some data is repeated. For example:
Converts it to:
<PK_CONTRATO> 1024098790010836478 1024098790010836478
It cause the XML to be unreadable or unreliable.
This error is always close to the 2000 line (or the 674000 character).
We have also observed that this error happens to us more frequently when the XML has to return names with the character "ñ".
Because we can not reproduce the error with smaller or concrete tables than an output with NIFs, we can not pass the data to you.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document