Re: Call Sqlldr from DOS Batch.

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 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??

> 
> 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".

Yours,
Lauernz Albe Received on Wed Mar 26 2008 - 04:37:49 CDT