This discussion is archived
1 Reply Latest reply: Jul 30, 2013 6:09 AM by Srini Chavali-Oracle RSS

SQL Loader: handling difference datatypes in data file and table column

3cd7ad85-b56c-4a9c-ae91-83be047aac2c Newbie
Currently Being Moderated

Hi,

 

I am not sure if my question is valid but I am having this doubt.

 

I am trying to load data from my data file into a table with just a single column of FLOAT datatype using SQL Loader. But very few insertions take place, leaving a large number of record rejected for the same reason-

 

Record 7: Rejected - Error on table T1, column MSISDN.

ORA-01722: invalid number

 

The data in my datafile goes like this: (with a single space before every field)

   233207332711<EOFD><EORD>    233208660745<EOFD><EORD>    233200767380<EOFD><EORD>

 

Here I want to know if there is any way to type cast the data read from the data file to suit my table column's datatype.

 

How do I handle this? I want to load all the data from my datafile into my table.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points