Re: Call Sqlldr from DOS Batch.

On Mar 25, 1:13 pm, PowerOne <salazar.wi...@xxxxxxxxx> wrote:
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 9.2.0.1.0 - 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

I'll ask this again:

Will you POST the contents of your parfile??


David Fitzjarrell
.