Invoking host command using PL/SQL..

From: Makarand Natu <Makarand.Natu_at_originindia.com>
Date: Sat, 15 Jul 2000 14:09:14 +0530
Message-Id: <10559.112129@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Invoking host command using PL/SQL..</TITLE>
</HEAD>
<BODY>

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.
Received on Sat Jul 15 2000 - 03:39:14 CDT