My Oracle Support Banner

Error With A XML Output (Doc ID 2257693.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 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:

  <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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.