Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Return code from SQL*LOADER
This is new behavior. In 7.3 version of SQL*Loader return code was 0 for such cases. Now (version 8.0 and higher) it's 2. So it's not your fault.
In article <92gfrd$3m3$1_at_nnrp1.deja.com>,
ttkach_at_my-deja.com wrote:
> Hey,
>
> It appears that SQL*LOADER returns a "2" back to the command line
after
> running a SQL*LOADER script that generates discards as a result of
> records failing a WHEN clause statement.
>
> Does anyone know if this is in fact how SQL*LOADER treats discards, or
> do I have some other problem I am missing?
>
> Thanks in advance,
>
> Todd
>
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/
Received on Fri Dec 29 2000 - 10:32:51 CST