Re: SQL Loader return code from batch file under NT

I'm not entirely sure about sqlldr80.exe return codes, I would imagine oracle has not change them at all.

NT Command files are the absolute worst thing to try and write any scripting with.

IF ERRORLEVEL x should be read as: IF ERRORLEVEL <= x THEN

that is if your script says
IF ERRORLEVEL 3 GOTO :END if sqlldr80 returns a 0, 1, 2 or 3, it will goto the end tag. If you want to trap individual return codes your script ends up looking like this:

IF ERRORLEVEL 0 GOTO :GotA0
IF ERRORLEVEL 1 GOTO :GotA1
IF ERRORLEVEL 2 GOTO :GotA2
IF ERRORLEVEL 3 GOTO :GotA3

and so on.

Guillaume LE MENER wrote:
>
> Hello,
>
> Could you help me ?
>
> I'am loading data from a text file with sqlldr80.exe in a batch file
> under NT, and i would like to know the return code of sqlloader.
>
> I've tried IF ERRORLEVEL but it seems return the same error level in any
> case.
>
> Have'you heard about that ?
>
> Do you if it's possible to execute sqlloader in another way ?
>
> Thank in advance and I hope I don't disturb you.

-- 
	Thomas Jones-Low		JobScheduler for Oracle
	tjoneslo_at_softstart.com		
	Ph: 802-652-1596		http://www.softstart.com