Message-Id: <10559.112131@fatcity.com> From: Krenn Philipp Date: Sat, 15 Jul 2000 12:46:22 +0200 Subject: 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!