Re: shell script from PL/SQL

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Wed, 28 Apr 1999 21:35:52 +0100
Message-ID: <7g7o1c$7qm$1@news.inet.tele.dk>

<adriancf_at_my-dejanews.com> wrote in message news:7g79ee$8o0$1_at_nnrp1.dejanews.com...
> Yes,
>
> But what I need is to do this from a Stored Procedure not from a command.
> Another tip?
>
> Thanks,
> Adrian
>
> In article <7g5bfh$nra$1_at_news6.svr.pol.co.uk>,
> "Martin Chadderton" <martinc_at_vicmar.freeserve.co.uk> wrote:
> > Hi,
> > Operating system commands can be run via the HOST command
> >
> > M.
> >
> > adriancf_at_my-dejanews.com wrote in message
> > <7g5adb$i4k$1_at_nnrp1.dejanews.com>...
> > >Hi all,
> > >
> > >Could anybody tell me how can I execute unix commands from PL/SQL
script.
> > >
> > >Thanks,
> > >Adrian
> > >
> > >-----------== Posted via Deja News, The Discussion Network ==----------
> > >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

In Oracle7 you need to build an RPC system using DBMS_PIPE and a listener. PLEX is just that and is a free downloadable utility from http://govt.us.oracle.com. In Oracle 8.0 and 8.1 you can use a feature called external procedures.

HTH. Finn Received on Wed Apr 28 1999 - 15:35:52 CDT