Error With A XML Output
Last updated on JANUARY 31, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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.
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