Re: Execute Unix Command from Stored Proc
From: Vikas Agnihotri <vikas_at_insight.att.com>
Date: 1996/11/04
Message-ID: <slrn57sngj.rdo.vikas_at_joshua.insight.att.com>#1/1
Date: 1996/11/04
Message-ID: <slrn57sngj.rdo.vikas_at_joshua.insight.att.com>#1/1
On Mon, 04 Nov 1996 15:24:41 -0500, Ed Jennings <jennings_at_dca.net> wrote:
>Is there a way to execute a standard unix command from a stored
>procedure? I want a stored proc to be able to touch a unix
>file at run time. Can this be done?
>
>Ed
If you are on Oracle 7.3 then take a look at the UTL_FILE standard package provided with the Oracle distribution. This provided a set of functions/tools to manipulate Unix files similar to fopen, fclose, etc in C.
If not, you could use the DBMS_PIPE package to accept a 'message' and then execute it. Look at the PLEX software at http://govt.us.oracle.com
HTH,
--Vikas
Received on Mon Nov 04 1996 - 00:00:00 CET