Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL*Loader-625: Multibyte character error in control file
Hi everyone,
Im trying to load a file into a table and I cant figure out what is
causing this ?
The message doesnt tell me too much, nor does the log file
what is this multi-byte character string ?? i searched the web for info and indications of the cause but nothing is obvious.
Its indicating something wrong with my control file (below) but its quite simple and straightforward and I used a working copy I had before and just changed the fields and the filename.
Any suggestions or ideas would be appreciated
thanks in advance
George Lewycky
NY City Transit
Brooklyn, NYC
gelewyc_at_nyct.com
SQL*Loader: Release 8.1.7.0.0 - Production on Thu May 2 10:07:31 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL*Loader-625: Multibyte character error in control file.
LOAD DATA
INFILE 'C:\MY SQL\cust_apr30.txt’
REPLACE
INTO TABLE TEMP_CUST_INT
FIELDS TERMINATED BY '","'
(ORIG_SYSTEM_CUSTOMER_REF,CUSTOMER_NAME,ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4,CITY,STATE,POSTAL_CODE,COUNTRY,INSERT_UPDATE_FLAG,CUSTOMER_CATEGORY
)
sample of: cust_apr30.txt
6277","SOUTHERN COACH MFG. CO. ","P. O. BOX 360028 "," "," "," ","BIRMINGHAM
","AL","35236","USA","I","37375","0","37375","A","CUSTOMER","
2719","GINNETTI TRUCKING CO. ","58 HEMINGWAY AVE "," "," "," ","EAST HAVEN
","CT","06512","USA","I","37375","0","37375","A","CUSTOMER","
8146","WINSTON CONTRACTING CORP ","115 ASPEN LANE "," "," "," ","TRUMBULL
![]() |
![]() |