Xref: alice comp.databases.oracle.tools:29019
Path: alice!news-feed.fnsi.net!news.interpacket.net!newspeer1.nac.net!news.maxwell.syr.edu!news-peer.gip.net!news.gsl.net!gip.net!den-news-01.qwest.net!qwest!nntphub.cb.lucent.com!news
From: Kenneth C Stahl <BluesSax@Unforgettable.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: operating system calls from PL/SQL
Date: Mon, 26 Jul 1999 07:48:46 -0400
Organization: Xyzzy Plugh Plover
Lines: 19
Message-ID: <379C4B1E.BEC7D2D@Unforgettable.com>
References: <37990760.4627580@news.mindspring.com>
Reply-To: BluesSax@Unforgettable.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.51 [en] (Win95; U)
X-Accept-Language: en-US,en

David Kaplan wrote:

> Hi,
>
> Similar to a host command in either sqlplus or in an Oracle forms
> environment - in order to execute an operating system call
>
> is their a way to execute operating system calls from within a pl/sql
> block - like in a stored procedure?
>
> I appreciate any input on this

The reason that there is no native ability to perform system calls from
within PL/SQL is because it would be too much of a security hole. If you
really need to intereact with the system then you must do it via
DBMS_PIPE.

Ken