SQLLDR Invalid Number on Record 2: Windows to Unix

From: The ants are driving me crazy <cwhankey_at_hotmail.com>
Date: 12 Oct 2006 07:54:37 -0700
Message-ID: <1160664877.837506.255880@b28g2000cwb.googlegroups.com>

I'm trying to load a text file from a Windows client onto a Unix-hosted Oracle database. The first record loads fine, but all subsequent records get errors such as "invalid number" or similar errors. Is this a Windows to Unix file format issue? If so, what is the solution? Don't lines in Windows text files end with CRLF and Unix lines end with LF? Is this the problem? By the way, the file originated from an IBM mainframe, but I believe that is irrelevant for this issue.

Listed below is a selection from my LOG file:

Table PO_ACTION, loaded from every logical record. Insert option in effect for this table: INSERT

   Column Name                  Position   Len  Term Encl Datatype


------------------------------ ---------- ----- ---- ----

---------------------

COMPANY                              1:2     2           CHARACTER

CONT_ID                              5:14    10           CHARACTER

TR_CODE                             16:17     2           CHARACTER

TR_DESC                             19:29    11           CHARACTER

SOURCE                              32:32     1           CHARACTER

TR_AMOUNT                           34:45     4           FLOAT

TR_DATE                             48:55     8           DATE MMDDYYYY

    NULL if TRANS_DATE = 0X3030303030303030(character '00000000')
DD                                  57:60     4           CHARACTER

PL4                                 62:65     4           CHARACTER

PL6                                 62:67     6           CHARACTER

POID                                69:70     2           CHARACTER

RES_AREA                            71:72     2           CHARACTER

Record 2: Rejected - Error on table PO_ACTION, column COMPANY. ORA-01722: invalid number

Record 3: Rejected - Error on table PO_ACTION, column TR_DATE. ORA-01858: a non-numeric character was found where a numeric was expected

Record 4: Rejected - Error on table PO_ACTION, column TR_DATE. ORA-01843: not a valid month Received on Thu Oct 12 2006 - 09:54:37 CDT