Sqlldr log shows wrong column name when facing ORA-01722

Viewed 134

I have a simple table with three columns.

Table name DUMMY20210527

desc DUMMY20210527

PID        NUMBER(10) 
VDATE      DATE       
SID        NUMBER(10) 

Control File

LOAD DATA CHARACTERSET JA16SJIS
APPEND INTO TABLE "DUMMY20210527" fields terminated by '\t' trailing nullcols
(
pid ,
vdate date "YYYY/MM/DD",
sid
) 

Data File

a   b   c
1   2019/01/10  X

When trying to load this file log is showing error in column vdate. however wrong value x is provided in column sid

Log

Record 1: Rejected - Error on table "DUMMY20210527", column VDATE.
ORA-01722: invalid number
Table "DUMMY20210527":
  0 Rows successfully loaded.
  1 Row not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

However if the following file is loaded then proper error message is shown

a   b   c
X   2019/01/10  1

Log

Record 1: Rejected - Error on table "DUMMY20210527", column PID.
ORA-01722: invalid number


Table "DUMMY20210527":
  0 Rows successfully loaded.
  1 Row not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

Oracle version used: Oracle 19c

0 Answers
Related