Home » RDBMS Server » Server Utilities » sql loader problems
sql loader problems [message #277545] Tue, 30 October 2007 08:55 Go to next message
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


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


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 Go to previous messageGo to next message
Messages: 7880
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)
Re: sql loader problems [message #277548 is a reply to message #277545] Tue, 30 October 2007 09:10 Go to previous message
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Could you post the full control file and the table definition.
Previous Topic: what happened when cange data during take export
Next Topic: import issue
Goto Forum:

Current Time: Wed Jul 26 06:00:13 CDT 2017

Total time taken to generate the page: 0.10254 seconds