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