Re: logg error line in unix

Have you tried to run sqlldr with BAD data?

Yechiel Adar
Mehish
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 02, 2003 4:44 PM

>
> Please give me an example on this.
>
>
> Roland
>
>
>
>
>
>
> Jack van Zanen
> <JACK_at_QUANTSYSTEM To: Multiple
recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> S.NL> cc:
> Sent by: Subject: RE: logg error
line in unix
> ml-errors_at_fatcity
> .com
>
>
> 2003-10-02 15:54
> Please respond to
> ORACLE-L
>
>
>
>
>
>
> Bad records go to bad file
> Logfile can be turned on with log parameter
>
> Jacob A. van Zanen
> Oracle DBA
> Quant Systems Europe b.v.
> Tel : +31 (0) 251 - 268 268
> Mobile: +31 (0) 6 51308813
> Fax: +31 (0) 251 - 268 269
> E-mail: mailto:jack_at_quantsystems.nl
> Visit our web site at http://www.quantsystems.nl/
>
>
>
> -----Original Message-----
> Sent: Thursday, October 02, 2003 3:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hallo again,
>
> I would like to get some help on this.
> I have a script called let us say test.sh and that script runs an
sqlloader
> script, which loads semicolonseparated data into an oracle table. I would
> like to have an example on how to log an error when trying to insert the
> data intothe table. I want the error to be both the error message and also
> tell me which line that is wrong in the file.
>
> So both errormessage and also complete line which is the error line.
>
>
> Thanks in advance
>
>
> Roland
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: roland.skoldblom_at_ica.se
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also send the HELP
> command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jack van Zanen
> INET: JACK_at_QUANTSYSTEMS.NL
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: roland.skoldblom_at_ica.se
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).