SQL loader In toad
559037Oct 9 2007 — edited Oct 9 2007I am trying to load the following data using the ctl written below through toad :
40,7,PR_SDIL,,,,STOPPED,TRANSACTION,0,0,0,9/23/2007 1:00:23 PM,,9/23/2007 1:00:23 PM,9/23/2007 1:00:23 PM,,,
LOAD DATA
INFILE 'C:\Documents and Settings\poduvalr\Desktop\ran.txt'
BADFILE 'C:\Documents and Settings\poduvalr\Desktop\ran.bad'
DISCARDFILE 'C:\Documents and Settings\poduvalr\Desktop\ran.dsc'
INTO TABLE "CONTROL_ATTRIBUTE_DETAIL"
(CONTROL_ATTRIBUTE_DET_ID,
CONTROL_ATTRIBUTE_ID INTEGER,
DET_ATTRIBUTE_NAME,
DET_ATTRIBUTE_TYPE,
DET_ATTRIBUTE_VALUE,
DET_ATTRIBUTE_DESC,
DET_ATTRIBUTE_STATUS,
DET_ATTRIBUTE_TABLE_NAME,
DET_READ_TOTAL INTEGER,
DET_INSERT_TOTAL INTEGER,
DET_UPDATE_TOTAL INTEGER,
DET_ATTRIBUTE_STARTTIME DATE "MM/DD/YYYY HH:MI:SS PM",
DET_ATTRIBUTE_NEXTUPDATE DATE "MM/DD/YYYY HH:MI:SS PM",
DET_ATTRIBUTE_ENDTIME DATE "MM/DD/YYYY HH:MI:SS PM",
DET_ATTRIBUTE_LASTUPDATE DATE "MM/DD/YYYY HH:MI:SS PM",
DT_STAMP INTEGER,
DT_CREATED DATE "MM/DD/YYYY HH:MI:SS PM",
DT_UPDATED DATE "MM/DD/YYYY HH:MI:SS PM"
)
and receiving the following error :
Record 1: Rejected - Error on table "CONTROL_ATTRIBUTE_DETAIL", column DET_ATTRIBUTE_STARTTIME.
ORA-01858: a non-numeric character was found where a numeric was expected
Since ,this normally happens if date format is wrong I couldnt find anything amiss here can anyone suggest what might be wrong .
Thanks