Re: Call Sqlldr from DOS Batch.

From: Laurenz Albe <>
Date: 26 Mar 2008 09:37:49 GMT
Message-ID: <>

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

Original text of this message