Help! I need a bad records tablev

From: Alvaro Illarze <illarze_at_chasque.apc.org>
Date: 1998/01/20
Message-ID: <885333279.967114769@dejanews.com>#1/1

Hi!

	I'm writing this because I'm having quite a big problem.
	I'm writing a sql*plus script for an Oracle 7 Server, to

automate a conversion from a char column to a date column. The thing is that there is at least one record which (I don't know why) is not a valid date. When Oracle finds this record, it display a warning and stop. How can I tell Oracle to go on working (and if possible send this record to a bad file table)??

        I know that SqlLoad do something like this (keeps on working and throw the record to a bad file), ANYBODY out there knows how can I make it work? I'll be very grateful.

                                                Alvaro Illarze

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Tue Jan 20 1998 - 00:00:00 CST