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


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

Original text of this message