SQL*Loader-625: Multibyte character error in control file ??????
Date: 10 May 2002 07:41:17 -0700
Message-ID: <68aecc05.0205100641.1ef12f30_at_posting.google.com>
Hello,
I'm stuck trying to load my flat text delimited file into my
oracle table (code and sample record below).
I've loaded tables before using the same procedure and format
but this time around I cant figure out whats causing this
multibyte error:
SQL*Loader-625: Multibyte character error in control file
Any ideas or suggestions would be appreciated
thanks in advance
george lewycky
create sql:
CREATE TABLE TBAGMASTER
sqlloader code:
LOAD DATA
(
ORIG_SYSTEM_CUSTOMER_REF VARCHAR2(240) NOT NULL,
CUSTOMER_NAME VARCHAR2(50),
ADDRESS1 VARCHAR2(240),
ADDRESS2 VARCHAR2(240),
ADDRESS3 VARCHAR2(240),
ADDRESS4 VARCHAR2(240),
CITY VARCHAR2(60),
STATE VARCHAR2(60),
POSTAL_CODE VARCHAR2(60),
COUNTRY VARCHAR2(60),
INSERT_UPDATE_FLAG VARCHAR2(1) NOT NULL,
LAST_UPDATED_BY NUMBER(15) NOT NULL,
LAST_UPDATE_DATE DATE DEFAULT SYSDATE,
CREATED_BY NUMBER(15) NOT NULL,
CREATION_DATE DATE DEFAULT SYSDATE,
CUSTOMER_CATEGORY_CODE VARCHAR2(30)
);
INFILE 'cust_apr30.txt’
INSERT INTO TABLE TBASMASTER
FIELDS TERMINATED BY '","'
(
ORIG_SYSTEM_CUSTOMER_REF,CUSTOMER_NAME,ADDRESS1,
POSTAL_CODE,COUNTRY,INSERT_UPDATE_FLAG,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
CREATED_BY,CREATION_DATE,CUSTOMER_CATEGORY_CODE
)
sample record from the data being loaded:
6277","SOUTHERN COACH MFG. CO. ","P. O. BOX 360028 "," "," "," ","BIRMINGHAM
","AL","35236","USA","I","37375","0","37375","A","CUSTOMER"," Received on Fri May 10 2002 - 16:41:17 CEST