Re: Unix Command From Stored Procedure

You can declare system libraries as libraries and call functions in procedures .... this is using extproc. One of the standard c libs allow you to run progams on the system... Hope this helps

Ghislain Gadbois wrote:

> Hi Scott,
>
> I've been able to do this using a Java Stored Procedure (assuming you
> are using Oracle 8i). Just do something like:
>
> /* ... */
> Runtime rt = Runtime.getRuntime();
> Process p = rt.exec("your UNIX command goes here");
> p.waitFor();
> /* ... */
>
> By the way, you may need the JAVASYSPRIV and JAVAUSERPRIV roles to make
> this work.
>
> HTH
>
> ----------------------------------------------------------------------------
> ----
>
> Ghislain Gadbois, Senior Programmer
> Sisca inc.
>
> Tel.: 1-819-564-1199, ext. 2225
> E-Mail: Ghislain.Gadbois_at_sisca.com
> Internet: http://www.sisca.com
>
> "Scott Buyer" <scottb_at_verio.net> a écrit dans le message news:
> 0l6F4.63051$AT6.66721_at_dfw-read.news.verio.net...
> > Does anyone know how to call a Unix command from an Oracle Stored
> > Procedure?? Can you ??
> >
> > --
> >
> >
> >
> > Thanks,
> >
> >
> > Scott Bieg
> > NTSC Inc
> > wk: 972.386.0908 #20
> > verio: 214-871-1629
> > email: sbieg_at_ntscdallas.com
> >
> >
Received on Sun Apr 30 2000 - 00:00:00 CDT