Re: invoke external programs from PL/SQL
From: Shay Shmelzer <shmelzer_at_johnbryce.co.il>
Date: 1996/07/07
Message-ID: <31DF97C2.18EF_at_johnbryce.co.il>#1/1
Date: 1996/07/07
Message-ID: <31DF97C2.18EF_at_johnbryce.co.il>#1/1
Frank Rose wrote:
>
> Hi,
>
> can anybody tell me how to invoke external programs form the opeating system
> from PL/SQL-procedures in an oracle 7 Database.
> To be more exact: we are using an oracle 7.2 database on an windows NT server
> 3.51. I have already tried to find some built-in packages that do, but no chance.
> Do I need some more packages ??
U need one package DBMS_PIPE . use a c program to check out commands that pl/sql puts in the pipe , and then executes them .
-- ++++++++++++++++++++++++++++++++++ |\/\/\| Shay Shmelzer | | E-mail : shmelzer_at_johnbryce.co.il OO ) Phone : 972-3-5765647 ISRAEL c | Organization: John Bryce Systems /___/ | ++++++++++++++++++++++++++++++++++ ) (Received on Sun Jul 07 1996 - 00:00:00 CEST