My Oracle Support Banner

When Loading A Numeric Column To A file And The Length is Fixed The Column Will be Padded with Spaces (Doc ID 2202908.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.1.3.0.1 [Release 12c]
Information in this document applies to any platform.

Symptoms

NOTE: In the example below, details including column names and their values represent a fictitious sample (based upon made up data used in an Oracle Demo instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

When load numeric column to a File and the physical length is set to a value (ex. 17), the column is implemented with spaces in the file.

Example:

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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