<div>
maybe this faq will help:<br />
<a href="http://orafaq.com/faqloadr.htm" rel="ugc">http://orafaq.com/faqloadr.htm</a>
</div>


maybe this faq will help:
http://orafaq.com/faqloadr.htm [http://orafaq.com/faqloadr.htm]

<div>
what do you mean call the control file from a shell script ?<br />
<br />
or you mean call sqlldr (with the control file as param) from a shell script ?
</div>


what do you mean call the control file from a shell script ?

or you mean call sqlldr (with the control file as param) from a shell script ?

<div>
The shell script would be as simple as:<br />
<br />
# start of script<br />
<br />
sqlldr user/pwd@host control=$1<br />
<br />
# end of script<br />
<br />
and you can call this script from the prompt as<br />
<br />
$&lt;script name&gt; &lt;control file name&gt;<br />
<br />
<br />
OR are you looking for something else?
</div>


The shell script would be as simple as:

# start of script

sqlldr user/pwd@host control=$1

# end of script

and you can call this script from the prompt as

$<script name> <control file name>


OR are you looking for something else?

<div>
I am looking for creating a batch job that executes a Sql loader process?<br />
<br />
Is it Possible..any examples<br />

</div>


I am looking for creating a batch job that executes a Sql loader process?

Is it Possible..any examples


<div>
What i exactly want is that i have a sqloader process being called from a .bat file.<br />
Now i want to know whether i can call this .bat file from an Oracle job.<br />
<br />
My Oracle version is 9.2.0.7
</div>


What i exactly want is that i have a sqloader process being called from a .bat file.
Now i want to know whether i can call this .bat file from an Oracle job.

My Oracle version is 9.2.0.7

<div>
<div class="content wysiwyg-content">
Is it possible to call an sqlloader control file from some script..say any shell scripts or batch scripts...Please explain in detail the possiblities..if you have examples then it would be much appreciated
</div>
</div>


Is it possible to call an sqlloader control file from some script..say any shell scripts or batch scripts...Please explain in detail the possiblities..if you have examples then it would be much appreciated

sql loader call

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.