Re: Unix Command From Stored Procedure

From: Ghislain Gadbois <Ghislain.Gadbois_at_sisca.com>
Date: Fri, 31 Mar 2000 14:45:58 -0500
Message-ID: <kf7F4.1776$A17.71512@wagner.videotron.net>

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 Fri Mar 31 2000 - 13:45:58 CST