Re: SQL Loader Question

From: Nuno Guerreiro <nuno-v-guerreiro_at_invalid.telecom.pt>
Date: Thu, 26 Nov 1998 10:18:16 GMT
Message-ID: <365e2a32.158390173_at_news.telecom.pt>

On Sun, 22 Nov 1998 14:12:13 +0100, "Koen Van Vaerenberg" <KoenVV_at_village.uunet.be> wrote:

>How do you crash Sql loader .
>I set the option (control file) Errors = 0, but he still does a normal
>completion in Oracle Financials.
>I really need the program to terminate in error when it encounters a bad
>record.
>
>Anyone ??
>
>Thanks in advance
>
>

Not a very elegant solution, but I'm checking if the .bad file is not empty with the "if [ -f file.bad ]" Unix shell command.

I've also tried checking the exit code returned by SQL*Loader, but no way, since SQL*Loader itself runs fine.

Hope this helps,

Nuno Guerreiro

---

As I don't normally appreciate unsolicited commercial e-mail (widely known as SPAM), I encoded my e-mail address. If you want to reply by e-mail, please remove the text added to fool spam software

"The art of arts, the glory of expression and the sunshine that lights the light of letters  is simplicity"

                                                        Walt Whitman Received on Thu Nov 26 1998 - 11:18:16 CET