Xref: alice comp.databases.oracle.tools:42108
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.nyc.globix.net!uunet!nyc.uu.net!ffx.uu.net!newsfeed.frii.net!news.psd.k12.co.us!den-news-02.qwest.net!qwest!wdc-read-01.qwest.net!not-for-mail
From: "Mike Dwyer" <dwyermj@co.larimer.co.us>
Newsgroups: comp.databases.oracle.tools
References: <38E51823.F14804C8@stthomas.edu> <38E55E9A.BBF1FD57@erols.com>
Subject: Re: PL/SQL function to execute an OS command
Lines: 41
Organization: Larimer County
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <aYoF4.3$2T2.5066@wdc-read-01.qwest.net>
Date: Sat, 1 Apr 2000 08:49:24 -0700
X-Complaints-To: news-admin@qwestip.net
X-Trace: wdc-read-01.qwest.net 954604422 204.133.54.49 (Sat, 01 Apr 2000 08:53:42 MST)
NNTP-Posting-Date: Sat, 01 Apr 2000 08:53:42 MST

Why not use "host"?

host('cp ' || v_file1 || ' ' || v_file2);

John Gasch <jgasch@erols.com> wrote in message
news:38E55E9A.BBF1FD57@erols.com...
> Use PLEX. The solution is a bit involved, but it works. The complete
> package and docs are available at
> osi.oracle.com/~tkyte/plex/index.html.  [Thomas Kyte's web page is a
> treasure chest of useful tools and new info (Thanks!).]
>
> Have fun
>
> John Gasch
>
> ----------------------
> Peter Rieckmann wrote:
> >
> > Hi,
> >
> > I am looking for a function that I could use to execute
> > a Unix command with in a PL/SQL block. Similar to the "$" in sqlplus.
> > Has any one see/user on of those functions?
> >
> > Thanks
> >
> > peter rieckmann
> > prieckmann@stthomas.edu
>
> > Hi,
> >
> > I am looking for a function that I could use to execute
> > a Unix command with in a PL/SQL block. Similar to the "$" in sqlplus.
> > Has any one see/user on of those functions?
> >
> > Thanks
> >
> > peter rieckmann
> > prieckmann@stthomas.edu