Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to execute UNIX command from PL/SQL??
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
![]() |
![]() |