Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to execute UNIX command from PL/SQL??

Re: How to execute UNIX command from PL/SQL??

From: Barbara Kennedy <barbken_at_teleport.com>
Date: Mon, 4 Dec 2000 19:56:08 -0800
Message-ID: <RGZW5.91$5_6.21374@nntp2.onemain.com>

That is true, but it is more involved and less platform portable. The metalink document has source code and everything. Jim
"Brian Peasland" <peasland_at_edcmail.cr.usgs.gov> wrote in message news:3A2BB5A7.DFE20A05_at_edcmail.cr.usgs.gov...
> You don't even have to be at Oracle 8i. If you are using Oracle 8, then
> you can do the same exact thing calling an external C program.
>
> HTH,
> Brian
>
>
> Barbara Kennedy wrote:
> >
> > If you are on Oracle 8i yes. You have to write a little Java class
 that
> > does this and use a pl/sql wrapper to call it. I saw an example on
> > metaLink. Search for Java and OS and pl/sql and I think yoiu will find
 a
> > document with the code and everything.
> > Jim
> > "Ivan Liu" <ivanliu_at_chttl.com.tw> wrote in message
> > news:90a9us$3q9_at_netnews.hinet.net...
> > > Hi,
> > > I had use PL/SQL to write some files
> > > into UNIX directory (definition in UTL_FILE_DIR).
> > >
> > > And I wish when user press a button,
> > > it can use UNIX command "tar" and "gzip"
> > > to compress those files to .tar.gz file automatic.
> > > (and better let UNIX know the file name which should be
 compressed)
> > >
> > > Is there any solution to do that interface?
> > > Thanks for help~~~ ^_^
> > > Ivan
> > >
> > >
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Mon Dec 04 2000 - 21:56:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US