Re: Call Sqlldr from DOS Batch.
Date: 26 Mar 2008 09:37:49 GMT
PowerOne <salazar.willy_at_gmail.com> wrote:
>>> 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 184.108.40.206.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??
> > No, I only need to store the user/password_at_dbname in another file. Is > this possible in this way?
Nobody can tell you what you did wrong unless you tell us what you did. Should be obvious.
As things are, all I can tell you is: use the correct syntax, and it will work. So the answer to your question is "yes".
Lauernz Albe Received on Wed Mar 26 2008 - 04:37:49 CDT