Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Return code from SQL*LOADER

Re: Return code from SQL*LOADER

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Fri, 29 Dec 2000 16:32:51 GMT
Message-ID: <92iebj$i1s$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US