Re: Problems with SQL*Loader and ORACLE 6

From: Kirk Bradley - Mainframe and Integration Technologies <kbradley_at_130.35.1.6>
Date: 9 Mar 1995 01:52:26 GMT
Message-ID: <3jln0q$9k7_at_dcsun4.us.oracle.com>


Is it possible that the data contains " characters and that is screwing up the enclosed by? Check the data stream

Mike Bearne (comrmb_at_herts.ac.uk) wrote:
: Hello,
 

: I'm in the process of trying to dump a load of data from some FoxPro tables
: (on a PC) into an ORACLE6 database (UNIX). In the long term I'm going to
: use ODBC to get this working however in the short term (*as I dont have the
: right ODBC software yet) I'm trying to get the data into ORACLE dy dumping
: it to a delimited text file and using the SQL*Loader to read it in to
: ORACLE. However I'm having some problems with the loader....
 

: The problems arise when I try to get a fairly large text field from a MEMO
: field in FoxPro to a LONG field in ORACLE. I keep getting the following
: sorts of errrors in the loader log file....
 

: -----
: Record 1: Warning - logical record longer than specified maximum.
: Record 2: Warning - logical record longer than specified maximum.
: Record 2: Rejected - Error on table ADVICE, column NAME.
: SQL*Loader-620: Initial enclosing character not found
: Record 3: Warning - logical record longer than specified maximum.
: Record 3: Rejected - Error on table ADVICE, column NAME.
: SQL*Loader-620: Initial enclosing character not found
: -----
 

: Here is a dump of the control file I am using.....
 

: -----
: LOAD DATA
: INFILE advice.txt
: APPEND
: INTO TABLE advice
: FIELDS TERMINATED BY ',' ENCLOSED BY '"'
: (name,advice.no,role,disability,division,author,source,advice
: CHAR(5000),pictptr,vidptr)
: -----
 

: where 'advice' is the LONG (memo) field.
 

: Can anybody explain why this isn't working ? I'have tried removing all
: carriage returns from the text file but to no avail,
 

: Cheers,
 

: Mike.

--
Kirk Bradley
Oracle Corporation
Mainframe and Integration Technologies Group
Received on Thu Mar 09 1995 - 02:52:26 CET

Original text of this message