My Oracle Support Banner

RETL Fixed Length Imports Not Correct With Multi-byte/special Characters (Doc ID 3044011.1)

Last updated on AUGUST 28, 2024

Applies to:

Oracle Retail Extract Tranform and Load - Version 13.2.9 and later
Information in this document applies to any platform.

Goal

The RETL import process fails when processing fixed length data which contains multi-byte / special characters like "£", ...

How can we set the RETL to accept and import special characters properly, following the positional structure?

Steps to recreate:
1 - Create a RETL import process (schema file and ksh to execute)
2 - Create a .dat file with data (containing special character) to load
3 - Move files to server to corresponding folders
4 - Execute RETL process
5 - Process aborts

error received
SQLException caught ---
java.sql.BatchUpdateException: ORA-12899: value too large for column "RMS"."TEST_SPECIAL_CHARS_IMPORT"."EMP_ID" (actual: 13, maximum: 10)
Message: ORA-12899: value too large for column "RMS"."TEST_SPECIAL_CHARS_IMPORT"."EMP_ID" (actual: 13, maximum: 10)
XOPEN SQL State: 72000
 

Solution

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