I am working on Sql*loader.In my csv file or flat file,i have date records and few records having date like 31-feb-2010.now am loading data into my table, at that time am getting error due to that wrong date(31-feb-2010).because of this no record was inserted into my table.
here what i want is
1.if am getting this error also ,i want to get inserted all remaining records into my table except that error record.
2.if am getting wrong dates in Csv file .how to handle that error while writing control file.
Please give solution for this.

Thanks in advance.
Pavani

In controlfile, first line: OPTIONS (ERRORS=0)
Once all records are loaded, fix the data in the "bad" file and load that file.
-- Or --
Create external table (bypass sql*loader) and validate + load the data using sql.

Or, write a function that'll accept "date" values from the CSV file, decide whether it is valid or not (and fix it if that's the case) and return a valid value. You'd use that function in SQL*Loader control file, such as

Once all records are loaded, fix the data in the "bad" file and load that file.
---thank you so much.
now its working now.
-- Or --
Create external table (bypass sql*loader) and validate + load the data using
sql.
--can explain in detail because how to bypass sql*loader.

Thanks in advance.
Pavani.

write a function that'll accept "date" values from the CSV file, decide whether it is valid or not (and fix it if that's the case) and return a valid value. You'd use that function in SQL*Loader control file,
such as ...date_column date "my_date_fix_function (:date_column)",
--------
Okay but how function will take date values from CSV file.

thanks
Pavani.

When you create external table, you can query the csv data as regular table using sql commands.

Check out the "Organization External" clause in the fine Oracle® Database SQL Language Reference.

As I told you in my previous message; didn't you see that piece of code?