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>
","CT","06611","USA","I","37375","0","37375","A","CUSTOMER","
Received on Thu May 02 2002 - 16:25:57 CEST
Date: 2 May 2002 07:25:57 -0700
Message-ID: <68aecc05.0205020625.7e9a839a_at_posting.google.com>
Any suggestions or ideas would be appreciated
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
","CT","06611","USA","I","37375","0","37375","A","CUSTOMER","
Received on Thu May 02 2002 - 16:25:57 CEST