Re: PL/SQL function to execute an OS command

From: Mike Dwyer <dwyermj_at_co.larimer.co.us>
Date: Sat, 1 Apr 2000 08:49:24 -0700
Message-ID: <aYoF4.3$2T2.5066_at_wdc-read-01.qwest.net>


Why not use "host"?

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

John Gasch <jgasch_at_erols.com> wrote in message news:38E55E9A.BBF1FD57_at_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_at_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_at_stthomas.edu
Received on Sat Apr 01 2000 - 17:49:24 CEST

Original text of this message