Home » RDBMS Server » Server Utilities » sqlldr return code in Windows platform ...
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.
Previous Topic: Load data of choice
Next Topic: Send Mail thru Oracle 9i Database by UTL_SMTP, plsql.jar not found
Goto Forum:
  


Current Time: Wed Dec 25 18:39:40 CST 2024