sql*loader problem

[manjunathk]

Hi guys,
I am trying to load a table with two columns(id number,num varchar2(10)) from a text file.I am getting the following error. How to go about solving it?
**************************************
Table CRDB.TEST1, loaded from every logical record.
Insert option in effect for this table: INSERT

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ID FIRST 1 CHARACTER
NUM NEXT 1 CHARACTER

Record 1: Rejected - Error on table CRDB.TEST1, column ID.
ORA-01722: invalid number

*********************************************
Also, for end of file should we mention something at the end of text file like a backslash etc?
thanks
manjunath

[vidhya]

Looks like there is a mismatch in datatype, the column "id" is number but is being inserted as a character datatype.

hope this helps,
vidhya

[dba_sys]

Hi,

If you could send your control file ,then probably we couls answer it more correctly.

Anand