Re: invoke external programs from PL/SQL

In article <31D94CB4.15_at_wiwi.uni-frankfurt.de>, <rose_at_wiwi.uni-frankfurt.de> writes:
> Path: rocksanne!parc!news.Stanford.EDU!nntp-hub2.barrnet.net!news.PBI.net!news.mathworks.com!fu-berlin.de!news.dfn.de!zeus.rbi.informatik.uni-frankfurt.de!grapool30.rz.uni-frankfurt.de!news
> From: Frank Rose <rose_at_wiwi.uni-frankfurt.de>
> Newsgroups: comp.databases.oracle
> Subject: invoke external programs from PL/SQL
> Date: Tue, 02 Jul 1996 18:22:12 +0200
> Organization: IWI - Uni Frankfurt
> Lines: 16
> Message-ID: <31D94CB4.15_at_wiwi.uni-frankfurt.de>
> NNTP-Posting-Host: duke.wiwi.uni-frankfurt.de
> Mime-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> X-Mailer: Mozilla 2.01 (WinNT; I)
> CC: rose_at_wiwi.uni-frankfurt.de
>
> 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 ??
>
> Any hints appreciated. Please mail answers to my email address:
> rose_at_wiwi.uni-frankfurt.de.
>
> thanks in advance
>
> Frank Rose
> Institute of Applied Computer Sciences
> Frankfurt University
>

We have used DBMS pipes to do this. From PL/SQL establish a pipe and pipe all the commands to this pipe. Write a pro-c code and monitor this pipe and use system command(in pro-c) to execute what ever comes out of pipe. This approach should work on any operating system.

Ravi Kasarla
Xerox Corp.
Ravi_Kasarla_at_wb.xerox.com Received on Fri Jul 05 1996 - 00:00:00 CEST