Error With A XML Output (Doc ID 2257693.1)

Last updated on APRIL 25, 2017

Applies to:

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

Symptoms

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:

  <PK_CONTRATO> 1024098790010836478

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.

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