Re: Call Sqlldr from DOS Batch.
Date: Tue, 25 Mar 2008 11:54:51 -0700 (PDT)
Message-ID: <3e4b7e8b-4e68-48a8-a436-1a5cc063adcb@c65g2000hsa.googlegroups.com>
On Mar 25, 1:13 pm, PowerOne <salazar.wi..._at_gmail.com> 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 Received on Tue Mar 25 2008 - 13:54:51 CDT