Re: How to run *.bat file on NT from O8?

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Thu, 20 May 1999 22:38:50 +0100
Message-ID: <7i1s1o$1qu$1@news.inet.tele.dk>

Patrick van Zuilen <patrick.van.zuilen_at_capgemini.nl> wrote in message news:3742A6C0.1EBCACDB_at_capgemini.nl...
> All,
>
> Is it possible to call /run a batch file on a windows NT file system
> from a stored procedure on the Oracle 8 NT Database Server to start an
> external event?
>
> Thanks,
> Patrick
>
>

The External Procedures facility in Oracle8 is perfect for this. You create a DLL in C that implements a HOST fuction which basically calls the Win32 CreateProcess (it was WinExec in the old Win16 days) and you're off. You then use the External Procedures facility to call this function from PL/SQL.

HTH. Finn Received on Thu May 20 1999 - 16:38:50 CDT