sqlldr return code in Windows platform ... [message #112060] |
Tue, 22 March 2005 14:02 |
orgee
Messages: 1 Registered: March 2005
|
Junior Member |
|
|
We are using Oracle 8.1.0.5 on a Windows 2000 platform. When we are running sqlldr as part of a batch file, we always get a return code of 0, indicating success even when there is a failure.
The failure is clearly mentioned in the log file though the return code seems to indicate everything is fine.
Have anyone else encountered similar problems?
Here are the contents of the batch file:
Sqlldr DBNAME/PWD bad = 'CUSTHEADER.bad' data = 'CUSTHEADER.DAT' discard = 'CUSTHEADER.dis' control='CUSTHEADER.CTL' SILENT = (HEADER) log='CUSTHEADER.LOG' readsize=2158848 bindsize=2158848 ROWS=10000 errors=0
echo %ERRORLEVEL%
pause
Thanks for your help.
|
|
|