<div>
I have a form with the WHEN-BUTTON-PRESSED trigger that executes the following code which launches the SQl loader.<br />
<br />
this is an example of the code.<br />
<br />
host ('sqlldr.exe vail_wt/superman@enterpris<wbr />e control=V:\VAILTECH\WATER\<wbr />modecode\D<wbr />MODE.CTL')<wbr />;<br />
<br />
hope this helps :)
</div>


I have a form with the WHEN-BUTTON-PRESSED trigger that executes the following code which launches the SQl loader.

this is an example of the code.

host ('sqlldr.exe vail_wt/superman@enterprise control=V:\VAILTECH\WATER\modecode\DMODE.CTL');

hope this helps :)

<div>
From the SQL file you may write -<br />
<br />
HOST sqlldr &lt;username&gt;/&lt;password&gt;@&lt;hos<wbr />tname&gt; &lt;your control file&gt;<br />
<br />
Does it help??<br />

</div>


From the SQL file you may write -

HOST sqlldr <username>/<password>@<hostname> <your control file>

Does it help??


<div>
<div class="content wysiwyg-content">
Does anybody know how to execute sqlldr from within a sql shell script? &nbsp;Something like:<br />
<br />
select sysdate from dual;<br />
<br />
@ /sqlldr apps/apps@db data.ctl;<br />
<br />
select sysdate from dual;<br />

</div>
</div>


Does anybody know how to execute sqlldr from within a sql shell script?  Something like:

select sysdate from dual;

@ /sqlldr apps/apps@db data.ctl;

select sysdate from dual;


SQL Load from within another script

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.