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



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.


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