Hi, all,
I am trying to load an excel file into oracle by using sqlldr,
there are 49 records, I can only put into 4, the other 45 complains about field in data file exceeds maximum length. the problematic column is PPP_FULL_DESC, oracle table has varchar2(4000), I am sure the length of the column in excel is shorter than 4000. Why it gave such errors? Thanks for help

Record 3: Rejected - Error on the table PPP_DETAILS_TMP, column PPP_FULL_DESC. Field in data file exceeds maximum length.


SQL> desc ppp_details_tmp;
Name Null? Type
----------------------------------------- -------- ----------------------------
PPP NOT NULL NUMBER(5)
PPPOPTION NOT NULL VARCHAR2(40)
PPPEXPLANATION VARCHAR2(250)
PPP_FULL_DESC VARCHAR2(4000)


Thanks for help.

Dave F.