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: Sat, 2 Dec 2000 09:04:36 -0800
Message-ID: <T_9W5.680$Y4.224153@nntp1.onemain.com>

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
>
>
Received on Sat Dec 02 2000 - 11:04:36 CST

Original text of this message

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