I went through the posts related to preserving blank spaces(adding env variables APT_ORACLE_PRESERVE_BLANKS) and tried them out. But still my job is getting aborted.
I have blanks in some of the character fields coming from input file and want to store them as blanks instead of NULL in oracle table.
When the above environment variable is not added, the job ran fine but the blanks were stored as null in the database.
When I set the APT_ORACLE_PRESERVE_BLANKS to True, the job aborted with the following error message(in sql loader log file):
Code: Select all
Record 1: Rejected - Error on table "APPS"."XXX", column POS_VOID_CD.
ORA-12899: value too large for column "APPS"."XXX"."POS_VOID_CD" (actual: 3, maximum: 1)
When I import the metadata from table in the oracle stage, the column definition was imported as VARCHAR -UNICODE -LENGTH 3.
I do not understand, why the metadata imported to the stage is having length 3, though table definition in oracle is showing as Varchar2(1 char).
Thanks in advance.
Regards,
ssunda