Hi,
Finally got an answer back from Oracle. sqlldr
in 8.1 has a bug (1327439) which does not display
the error when errors=0.
Supposedly fixed in 8.1.6.3
Paul
- Paul Parker <paul_g_parker_at_yahoo.com> wrote:
> On 8.1.6, when setting errors=0 a a sqlload, a
> "bad" record gets rejected but sqlldr does not
> report the actual error, only specifying
> 'MAXIMUM
> ERROR COUNT EXCEEDED'.
>
> If errors is set to anything greater than 0, a
> meaningful error is displayed. Does anybody
> know
> of a way to see the proper error message when
> specifying errors=0 (since we do not want the
> load to continue if an error is encountered)?
>
> Thanx in advance
>
>
> Do You Yahoo!?
> Yahoo! Photos - 35mm Quality Prints, Now Get 15
> Free!
> http://photos.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Paul Parker
> INET: paul_g_parker_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
Received on Mon Oct 09 2000 - 12:39:14 CDT
