SQLLDR field in data file exceeds max. length Problem - HELP

From: Lucia DeMeester <ldemeester_at_nm2.com>
Date: Mon, 11 Sep 2000 15:34:30 -0700
Message-Id: <10616.116674@fatcity.com>

Lister,

I have a column which was set up to varchar2(4000). Somehow the loader rejects some of the records indicating Record xx: Rejected - Error on table ICOD_FAQ_TYPE, column FAQ_TEXT.
Field in data file exceeds maximum length. However, if I checked the .bad file and counted the column, it is not over 4000 characters. Is that because some of the special character cause the record rejection? Has anyone had these problems?

Thanks in advance.

Regards,
Lucia

desc icod.icod_faq_type;

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
----
 FAQ_TYPE_ID                               NOT NULL VARCHAR2(4)
 FAQ_TITLE                                 NOT NULL VARCHAR2(100)
 FAQ_TEXT_TITLE                                     VARCHAR2(100)
 FAQ_TEXT                                           VARCHAR2(4000)
 IS_FAQ                                             NUMBER(3)
 ACTIVE                                             NUMBER(3)
 SEQ_NO                                    NOT NULL NUMBER(3)

Here is my control file:

LOAD DATA
INFILE icod_faq_type_a.dat
append INTO TABLE icod_faq_type
FIELDS TERMINATED BY "|"

(faq_type_id,
 faq_title,
 faq_text_title,
 faq_text,

 is_faq,
 active,
 seq_no )

Rejected .bad file:
FRBY|Gift Orders|Gift Orders|Your gift messsage can be included at no additional charge. Simply let us know and we'll print it on the packing slip. For just \$4 each, we'll send your gifts in our festive paper finished with ribbon. Gift wrap is not available for some large items, furniture and items shipped directly from the supplier.|1|0|91 tele|Phone Orders|Phone Orders|Our toll-free line <B>1-800-662-5616</B> is open 24 hours a day, except Christmas and New Years Day. To help speed your ordering, please have your credit card ready and have the completed order form handy. We will gladly confirm availability and advise you of delivery dates. You will not be charged until you order is shipped.|1|1|70 info|Fax & Mail Orders|Fax & Mail Orders|Orders may be faxed to our toll-free number <B>1-800-583-4922</B> 24 hours a day. Please complete the order form in our most recent catalog and include your credit card information and your daytime phone number. If a transmission problem occurs, please mark the second fax as "Possible Duplicate-Transmission Problem".^M ^M To place mail orders, complete the order form in our most recent catalog and send it in the attached self-addressed envelope.|1|1|102 retn|Returns & Exchanges|Returns & Exchanges|If you are not completely satisfied, just return your purchase to us for an exchange or refund. Simply follow the instructions on the packing slip enclosed in your order or call our Customer Service Department at <B>1-800-662-5616</B>. <B>Personalized Received on Mon Sep 11 2000 - 17:34:30 CDT