Re: SQL*Loader

From: Joep Hendrix <joep.hendrix_at_wxs.nl>
Date: 1998/06/13
Message-ID: <3581AA20.4F80_at_wxs.nl>#1/1


dmurphy7_at_my-dejanews.com wrote:
>
> I am trying to load a file that contains many records of a tab delimited file
> that contains raw laboratory results. There is a specific structure to this
> file. I have SQL*Loader working properly, however, I would like to ONLY
> commit all records if no errors are found. In other words, if there is a
> problem with any of the records, the whole file (and all of its records)
> should not be loaded.
>
> I have played with the ERRORS and DISCARDMAX parameters and they seem to stop
> the execution of the load, but do not "rollback" any records that were read
> above it.
>
> Can anyone lend a hand?
>
> Dan Murphy
> dmurphy_at_hiv.hjf.org
>
> -----== Posted via Deja News, The Leader in Intert net Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

Why do you want all these difficult things to manage with loader. It is not a programming language. Just load into a temoporary table and then use pl/sql to filter and put the result records in definate table.

Joep Hendrix Received on Sat Jun 13 1998 - 00:00:00 CEST

Original text of this message