Message-Id: <10559.112129@fatcity.com> From: Makarand Natu Date: Sat, 15 Jul 2000 14:09:14 +0530 Subject: Invoking host command using PL/SQL.. This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFEE38.2B445BF0 Content-Type: text/plain Hi Listers, Urgent help requested on the following.. I'm using Oracle Web App. Server. 3.0 on Solaris 2.6/NT. The database server runs Oracle 7.3 on Solaris 2.5. One of the application function displays an HTML form requesting the user to enter a file to be uploaded. After the uploaded file is received on the app. server it needs to be saved in a pre-configured path. Then i need to call SQL*LOADER which would load the data within this file to the database. The SQL*LOADER call is contained within a batch file. So I need to run the batch file. All the above actions need to immediately happen after user selects the "upload file" file and presses the submit button on the HTML form mentioned above. Can this be handled using a PL/SQL cartridge calling stored procedures/packages ? Also how do i invoke host command using stored procedure ? Any suggestion/idea for the above problem would be highly appreciated. Thanks in advance! Mak. ------_=_NextPart_001_01BFEE38.2B445BF0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable Invoking host command using PL/SQL..

Hi Listers,

Urgent help requested on the = following..

I'm using Oracle Web App. Server. 3.0 = on Solaris 2.6/NT. The database
server runs Oracle 7.3 on Solaris = 2.5.
One of the application function = displays an HTML form requesting the user to enter a file  to be = uploaded. After the uploaded file is received on the app. server it = needs to be saved in a pre-configured path. Then i need to call = SQL*LOADER which would load the data within this file to the database. = The SQL*LOADER call is contained within a batch file. So I need to run = the batch file.

All the above actions need to = immediately happen after user selects the "upload file" file = and presses the submit button on the HTML form mentioned above.
Can this be handled using a PL/SQL cartridge calling stored = procedures/packages ?
Also how do i invoke host command = using stored procedure ?

Any suggestion/idea for the above = problem would be highly appreciated.

Thanks in advance!
Mak.