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
gel...@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","
Look at your control file carefully. Looks as if you got your INFILE name
ending with garbage.
---
Jon Yi, ??? software engineering with C, Oracle, Unix, Tcl, MS Access, and
Shell programming.