Hello,
I do not understand why the following control file failed to load data into an
existent table.
The table was created by:
my $create_table = qq{CREATE TABLE SEQUENCE ( ACC VARCHAR2(15), HEADER VARCHAR2(125),
SEQ CLOB )};
content of control file:
LOAD DATA
INFILE 'seq.txt'
INTO TABLE SEQUENCE
FIELDS TERMINATED BY ","
(ACC,
HEADER,
SEQ)
Error message in the log file:
"Record 1: Rejected - Error on table SEQUENCE, column SEQ.
Field in data file exceeds maximum length"
Can anyone tell me why CLOB is not doing what I hoped, which was to take a long string
of characters for the field SEQ?
Your help is greatly appreciated.
Bob Xiong
_______________________________________________
Boston-pm mailing list
[EMAIL PROTECTED]
http://mail.pm.org/mailman/listinfo/boston-pm
