Re: calling external programs from PL/SQL

From: siim <siim_at_NOSPAM_specht.demon.co.uk>
Date: 1998/04/06
Message-ID: <3528cebc.17585434@news.demon.co.uk>#1/1

On Mon, 06 Apr 1998 10:09:56 GMT,
Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de (Gerhard Moeller) wrote:

>Hi, is there a way to call external programs from PL/SQL?
>
>Gerhard.
>--
>Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE
> ICQ PIN: 2804938
>OFFIS | | | | | | Tel.: 0441/9722-122
>Escherweg 2 | | | | | | Sekr.: 0441/9722-113 oder -101
>D-26121 Oldenburg |O|F|F|I|S| Fax: 0441/9722-102

For Oracle 7.3: Use pipes. See Chapter 8 in Oracle 7 Server, Application Developer's Guide.

You'll have to write a PL/SQL procedure and an external program (C, FORTRAN, whatever) that communicate through pipes. It's the external program that actually launches the app you want to run.

Ivan Received on Mon Apr 06 1998 - 00:00:00 CDT