sql loader problems [message #277545] |
Tue, 30 October 2007 08:55 |
dieforsql
Messages: 1 Registered: October 2007
|
Junior Member |
|
|
i had a problem when i am trying to load some data into the database.
within the control file the field description is given as
"DATAFEEDSTATUS" NULLIF "DATAFEEDSTATUS"=BLANKS,
but when i try to load this field the error i am getting is
Record 2: Rejected - Error on table SP_SERVICEPROVISIONINGREQUEST, column "DATAFEEDSTATUS".
ORA-01722: invalid number
and the data iam having is of type
LHLRDP,2,9868373859,404680000464207
all the above data is in the same column of the table.
please help me with your suggesstions how the same data can be loaded into the database.
|
|
|
Re: sql loader problems [message #277547 is a reply to message #277545] |
Tue, 30 October 2007 09:07 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Show us a bit more of your control file please.
How on earth can we say anything based on such a tiny bit of info?
(Except that LHLRP is not a number, nor is the complete string)
|
|
|
|