Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

145 views
Skip to first unread message

george lewycky

unread,
May 2, 2002, 10:25:57 AM5/2/02
to
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
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","

JON

unread,
May 2, 2002, 3:34:30 PM5/2/02
to
"george lewycky" <gel...@nyct.com> wrote in message
news:68aecc05.02050...@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
> 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&#8217; <<<<<--------Here

> REPLACE
> INTO TABLE TEMP_CUST_INT
> FIELDS TERMINATED BY '","'
>

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.


0 new messages