SQL*Loader-625: Multibyte character error in control file

From: george lewycky <gelewyc_at_nyct.com>
Date: 2 May 2002 07:25:57 -0700
Message-ID: <68aecc05.0205020625.7e9a839a_at_posting.google.com>


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&#8217; 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

","CT","06611","USA","I","37375","0","37375","A","CUSTOMER","
Received on Thu May 02 2002 - 16:25:57 CEST

Original text of this message