Hi, You can do this using a Java stored procedure. Don't have the time to write a full class for you, but you'll want to begin with something like this: CREATE OR REPLACE JAVA SOURCE NAMED "execProg" AS import java.io.*; public class execProg { public static void execute(String prog) { try { String[] cmd = new String[2]; cmd[0] = "c:\\windows\\system32\\cmd.exe"; cmd[1] = prog; final Process proc = Runtime.getRuntime().exec(cmd); } catch (Exception e) {} } }; .. then you'll need to add a grant to allow the user to execute cmd.exe: BEGIN dbms_java.grant_permission('USERNAME','java.io.FilePermission','c:\\windows\\system32\\cmd.exe','execute'); END; / Hope this is a good starting point for you. (Note: Completely untested!!) Cheers, Phil On 26/01/06, John Dunn <jdunn@xxxxxxxxx> wrote: > I have a requirement to run some scripts on Windows from Oracle 9 stored > procedures. The stored procedures are written in PL/SQL although Java is an > option. > The scripts will be .bat files or perl or python programs. > > What is the best way to execute these from a stored procedure?. Oracle > database platform on Windows will be Oracle 9 or 10. > > > > John Dunn > Product Consultant > Direct Dial +44 (0) 117 373 6122 > Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. > Tel: +44(0) 117 373 6114 > Fax: +44 (0) 117 373 6115 > > www.sefas.com > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l