Re: Call Sqlldr from DOS Batch.

From: PowerOne <>
Date: Tue, 25 Mar 2008 11:13:34 -0700 (PDT)
Message-ID: <>

When I set the ORACLE_HOME to D:\oracle\ora92, the tnsping responde OK.
And I executed the Sqlldr and the data was Uploaded. But my problem now is to hide the user and password from the batch file.

When I write the user and password after the sqlldr command it works fine but
I need to put the user an password in another file like this: SQLLDR parfile=D:\myfile.par control=D:\myloader.txt log=mylog.log bad=mybad.bad errors=1000000 direct=true This is the message displayed:
LRM-00110: syntax error at 'connect'
LRM-00113: error when processing file 'D:\mypar.par' SQL*Loader: Release - Production on Tue Mar 25 14:10:46 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL*Loader-100: Syntax error on command-line Received on Tue Mar 25 2008 - 13:13:34 CDT

Original text of this message