My Oracle Support Banner

XML Export has Missing Lines if XML Content Contains New Lines (Doc ID 2668928.1)

Last updated on OCTOBER 04, 2022

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


In Oracle Data Integrator (ODI), an XML export results in missing lines if the XML content contains new lines (LF).

For example:

An XML file which includes empty lines is loaded initially into XML database tables using external database feature.

This is how the XML looks in Notepad++ (Show All Characters Option):

When exporting the content of the XML database tables into a new XML file using an ODI procedure with <> command, in the new XML file there are missing lines compared to the initial XML file:





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.