Hi Experts,
I am not able to load one Control characters "FF" and one latin script characters "Œ" to oracle table through SQLLDR.
please see below for the details,
DATABASE VERSION DETAILS:
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - ProductionVersion 19.25.0.0.0
DATABASE CHARACTERSET DETAILS:
NLS_CHARCTERSET : US7ASCII
TARGET TABLE DETAILS:
DESC HR.LOAD_TEST;
NAME Null? Type
----- ----- -------
CODE NOT NULL CHAR(3)
CONTROL FILE:
OPTIONS(ERRORS=0)
LOAD DATA
INFILE 'C\Users\gobi\Documents\sample_data.dat'
BADFILE 'C\Users\gobi\Documents\sample_data.bad'
DISCARDFILE 'C\Users\gobi\Documents\sample_data.bad'
TRUNCATE
INTO TABLE HR.LOAD_TEST
WHEN (1:3) <> 'SH4'
(
CODE position(1:3) char
)
INFILE DATA DETAILS:
Œ..
FF..
FS..
please see below screenshot for the infile data.
Note : i have shared 3 sample data.
in the 2nd and 3rd line first 2 characters are control character like block element. 2nd line first 2character is "form feed"
and 3rd line first 2 character is "File Separator". i can't post it here as block element i don't know how to do it here. in notepad++
we can insert using in the option edit->character panel ( value for ff 12, for fs 28).
issues is:
i am able to load 3rd data successfully but 1 and 2nd data not able to load. just it showing like "you can't insert null".
here first latin script character "Œ" and 2nd control characters "FF" not able to load. but i am able to load 3rd control character "FS".
kindly help on this. it is urgent one we are facing this issues in production.
NOTE : i can't post exact table field details and data in this place due to my organization policy.
Thanks!