Hi all.
I'm really stuck with this basic issue.
My table:
CREATE TABLE S13018_SQLLDR_DATA (
CATEGORY CHAR(3) NULL,
REGION VARCHAR2(36) NULL,
STATE VARCHAR2(36) NULL,
DISTRICT VARCHAR2(36) NULL,
ZONE_NAME VARCHAR2(36) NULL,
BUILDING_ID VARCHAR2(36) NULL,
TOTAL_COUNT NUMBER(6,0) NULL
)
/
The data
TEL|EASTERN REGION|PAHANG|PH|ZONE TERUNTUM|AAR|5206
TEL|SOUTHERN REGION|JOHOR|JS|ZONE SKUDAI / PONTIAN|AB|395
TEL|SOUTHERN REGION|JOHOR|JS|ZONE SENAI|ABN|229
TEL|SOUTHERN REGION|MELAKA|MK|ZONE MELAKA UTARA|ABU|635
TEL|SOUTHERN REGION|MELAKA|MK|ZONE MELAKA UTARA|AG|2986
TEL|SOUTHERN REGION|JOHOR|JU|ZONE KLUANG/MERSING|AH|1016
My control file is
load data
append
into table s13018_SQLLDR_DATA
fields terminated by "|"
trailing nullcols
(
CATEGORY CHAR(3),
REGION CHAR(36),
STATE CHAR(36),
DISTRICT CHAR(36),
ZONE_NAME CHAR(36),
BUILDING_ID CHAR(36),
TOTAL_COUNT INTEGER EXTERNAL
)
But when I execute the loading, all records were rejected with error:
[/code]Record 1: Rejected - Error on table S13018_SQLLDR_DATA, column TOTAL_COUNT.
ORA-01722: invalid number
Record 2: Rejected - Error on table S13018_SQLLDR_DATA, column TOTAL_COUNT.
ORA-01722: invalid number
Record 3: Rejected - Error on table S13018_SQLLDR_DATA, column TOTAL_COUNT.
ORA-01722: invalid number
Record 4: Rejected - Error on table S13018_SQLLDR_DATA, column TOTAL_COUNT.
ORA-01722: invalid number
Record 5: Rejected - Error on table S13018_SQLLDR_DATA, column TOTAL_COUNT.
ORA-01722: invalid number[/code]
Thank you.