Re: Testing DATE is correct with Oracle Loader

Put the desired date format in the control file for the date fields. Any data that does not adhere to this format will not be loaded and will be put in the discard file. You will have to specify the discard file in your call to sql loader.

HTH,
Venki

Stefan Duffner wrote:

> Hello,
>
> I have a problem with Oracle Loader and I hope anyone can help me.
> I try to import data from a textfile into Oracle which works
> perfectly.
> But I have some fields of DATE type and in these textfiles have
> sometimes incorrect dates like 33. of month etc.. But I want to put
> these data, which have incorrect date, into a discard file, but I dont
> know how I can check the date and writing it into the discard file.
>
> Thanks for any help
> Stefan
  Received on Tue Aug 07 2001 - 20:20:12 CEST