Re: Invoking host command using PL/SQL..

Hi!

You can use external Procedures. These are C-Programs which can be called like PL/SQL-Procedures.

regards,
Phil

Saturday, July 15, 2000, 11:44:11 AM, Your Mail:

MN> Hi Listers,

MN> Urgent help requested on the following..

MN> I'm using Oracle Web App. Server. 3.0 on Solaris 2.6/NT. The database
MN> server runs Oracle 7.3 on Solaris 2.5.
MN> One of the application function displays an HTML form requesting the user to
MN> enter a file  to be uploaded. After the uploaded file is received on the
MN> app. server it needs to be saved in a pre-configured path. Then i need to
MN> call SQL*LOADER which would load the data within this file to the database.
MN> The SQL*LOADER call is contained within a batch file. So I need to run the
MN> batch file.
MN> All the above actions need to immediately happen after user selects the
MN> "upload file" file and presses the submit button on the HTML form mentioned
MN> above.
MN> Can this be handled using a PL/SQL cartridge calling stored
MN> procedures/packages ?
MN> Also how do i invoke host command using stored procedure ?

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

MN> Thanks in advance! Received on Sat Jul 15 2000 - 05:46:22 CDT