| sqlloader error [message #269836] |
Mon, 24 September 2007 16:07  |
lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND
|
Member |
|
|
Hello All -
I am trying to load data into a table using sql loader but everytime I try I get a "second enclosure string not present" error message. Can anyone help out?
I have created the following:
CREATE TABLE "SYSTEM"."ASBESTOS_FILE_LIST_LJ"
( "FILE_ID" NUMBER(10,0),
"FACILITY_ID" VARCHAR2(20 BYTE),
"AREA" VARCHAR2(20 BYTE),
"DISTRICT" VARCHAR2(50 BYTE),
"FACILITY_NAME" VARCHAR2(100 BYTE),
"ZIPCODE" VARCHAR2(10 BYTE),
"FILEPATH" VARCHAR2(300 BYTE),
"FILENAME" VARCHAR2(100 BYTE),
"FOLDER" VARCHAR2(200 BYTE),
"FILE_SIZE" VARCHAR2(10 BYTE),
"FILE_TYPE" VARCHAR2(100 BYTE),
"FILE_TITLE" VARCHAR2(100 BYTE);
create sequence lj_sequence
increment by 1
start with 1;
CREATE OR REPLACE TRIGGER system.lj_trigger
BEFORE INSERT
ON asbestos_file_list_lj
FOR EACH ROW
BEGIN
SELECT system.lj_sequence.nextval
INTO :NEW.file_id
FROM DUAL;
END;
/
Here's my controlfile script:
load data
infile *
REPLACE
INTO TABLE SYSTEM.ASBESTOS_FILE_LIST_LJ
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "" TRAILING NULLCOLS
(
FACILITY_ID CHAR,
AREA CHAR,
DISTRICT CHAR,
FACILITY_NAME CHAR ,
ZIPCODE INTEGER EXTERNAL,
FILEPATH CHAR,
FILENAME CHAR,
FOLDER CHAR,
FILE_SIZE INTEGER EXTERNAL,
FILE_TYPE CHAR,
FILE_TITLE CHAR,
FILE_ID "LJ_SEQUENCE.NEXTVAL"
)
begindata
1444110,,,,,c:\lola\whatever.doc,whatever.doc,c:\lola,Word Document,,
|
|
|
|
|
|
| Re: sqlloader error [message #269854 is a reply to message #269836] |
Mon, 24 September 2007 20:31  |
 |
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
|
If you are trying to optionally enclose by double quotes, then it needs to be optionally enclosed by '"'. That is one double quote surrounded by two single quotes. Use your sequence in a trigger or the control file, not both. There may be other errors.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
