Xref: alice comp.databases.oracle:77903 comp.databases.oracle.misc:57827 comp.databases.oracle.server:91951 comp.databases.oracle.tools:42999
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news.mel.connect.com.au!not-for-mail
From: "Tom Zamani" <tomz@redflex.com.au>
Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Re: How to call shell script from PL/SQL ?.
Date: Thu, 20 Apr 2000 13:11:10 +1000
Organization: Customer of Connect.com.au Pty. Ltd.
Lines: 22
Message-ID: <8dlssp$8eb$1@perki.connect.com.au>
References: <38FDF480.9D00B0B1@att.com>
X-Trace: perki.connect.com.au 956200665 8651 203.63.133.169 (20 Apr 2000 03:17:45 GMT)
X-Complaints-To: abuse@connect.com.au
NNTP-Posting-Date: 20 Apr 2000 03:17:45 GMT
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

You need to provide us what version of database you are using.
If 7 then I have no Idea I am not sure if you can do that.
if 8.X you need to use external procedures in oracle
if 8.1.6 there is a package in oracle which could help you with this (I
don't know the name of the package).
I have used external procedures to do ftp ,cp, mv send email etc, and it is
very fast.

Tom

Raj <rajarulmani@att.com> wrote in message news:38FDF480.9D00B0B1@att.com...
> Hi,
>     can any one tell me how to call a shell script from PL/SQL ?.
>
> Thanks,
> Raj
>
>