Re: sql loader return codes

"Roman Fiedler" <roman.fiedler_at_t-online.de> wrote in message news:<9m18r1$na4$04$1_at_news.t-online.com>...
> hi out there,
>
> i've a problem with the sql*loader tool of oracle 8.1.6:
> i'm using the loader out of a c++ application (running on solaris) to load
> thousands of ascii data files into a table.
> for every single file the text output says 'all done without any errors'.
> but the return code of the system call always is 512.
> usually i would expect a rc of zero when everything is ok, because i know
> the following possible return codes:
>
> EX_SUCC 0
> EX_FAIL 1
> EX_WARN 2
> EX_FTL 3
>
> can anybody tell me the meaning of this return code, or better has a list of
> all possible return codes?
> i did not find anything about it in my oracle documentation and in the net.
>
> thx
> roman

IIRC there are no return codes provided by SQL*Loader. But of course you could also examine whether the .bad file is empty.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Aug 23 2001 - 13:35:24 CEST