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

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!
========================================