Re: sql loader

You can't. The row will be rejected and remain in a bad file, when specified.
A stable procedure to do this is to load your data in a 'technical' table with no constraints and validation at all and use ordinary sql,pl/sql to verify and validate and copy it to the production table. That said, you should be able to build a pl/sql function which simply does a select from dual, and returns the string 'FALSE' when the to_date in your select raised an exception and 'TRUE' when the to_date was succesful. Call this function in a DECODE and you're there.

Hth,

Sybrand Bakker, Oracle DBA

"Andreas Lommel" <him_lommel_at_t-online.de> wrote in message news:39852780.2186453_at_news.btx.dtag.de...
> Hi there. Ia want to load data ito a table-field. The data shall be a
> date. If the data is not a valid date there should be load value NULL
> in the field. How can I do this ?
Received on Mon Jul 31 2000 - 00:00:00 CEST