inexplicable sql loader error in loading delimited text [message #73338] |
Mon, 29 March 2004 11:49 |
Rusty Bobrow
Messages: 1 Registered: March 2004
|
Junior Member |
|
|
Can anybody explain what is happening here?
I am getting the following error from sql loader(version information
SQL*Loader: Release 9.2.0.1.0 - Production on Mon Mar 29 16:53:18 2004)
:
Record 1: Rejected - Error on table ADMIN_BLDG_R, column RMK.
Field in data file exceeds maximum length
This is bizarre because the field in question is a LONG, as shown in:
describe ADMIN_BLDG_R
Name Null? Type
----------------------------------------- -------- ----------------------------
WAC_INNR NOT NULL VARCHAR2(10)
RMK LONG
RMK_SEC_CLASS NOT NULL VARCHAR2(1)
MOD_DATE DATE
the sqlldr control file is:
LOAD DATA
INFILE "foo.txt"
INTO TABLE ADMIN_BLDG_R
FIELDS TERMINATED BY '|'
(
WAC_INNR,
RMK,
RMK_SEC_CLASS,
MOD_DATE "to_date(:MOD_DATE, 'MON DD YYYY HH:MIPM')"
)
and the data file is:
0059-08001|LIMITED OFFICE SPACE IS AVAILABLE IN THE MAIN BUILDING TRAIN. AIR TERMINAL (116' X 53') AIRCRAFT DISPATCH AND WAITING ROOM. NWS CANADA AREA OFFICE (100' X 50') OFFICIES, CARPENTER SHOP AND GENERAL WORKSHOP. FACILITY CONTROL OFFICE (122' X48') WITH 2 WINGS 16' X 52' EACH, COMMUNICATIONS EQUPMENT.|U|Dec 19 1997 5:30PM
|
|
|