Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Running scripts on Windows from Oracle stored procedures

Re: Running scripts on Windows from Oracle stored procedures

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 26 Jan 2006 07:55:59 -0500
Message-Id: <1138280159l.4389l.0l@medo.noip.com>

On 01/26/2006 05:55:59 AM, John Dunn wrote:
> Phil
>
> Thanks for that.
>
> I suspected that java was the way to go.
>
> One complication I do have is that some of the script to be run are on
> servers other than the database server.
>
> I presume I could use some form of rsh/ssh to run them...but do you know of
> a better option?

This may provide some help:

http://www.smashing.org/extproc_perl

It's Perl interpreter, implemented as and external procedure (you need EXTPROC listener) which can store Perl code either in the database itself or in the file system. Pretty cool stuff

-- 
Mladen Gogala
http://www.mgogala.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 26 2006 - 06:55:59 CST

Original text of this message

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