oracle如何使用java source调用外部程序

create or replace and compile java source named jv_run_extpro as

import java.io.*;

import java.lang.*;

import java.util.*;

import java.sql.*;

import oracle.sql.*;

publicclass jv_run_extpro

{

publicstaticvoid run(String cmd) throws IOException

{

Process p=Runtime.getRuntime().exec(cmd);

StreamGobbler errorGobbler = new StreamGobbler(p.getErrorStream(), "Error" );

StreamGobbler outputGobbler = new StreamGobbler(p.getInputStream(), "Output" );

errorGobbler.start();

outputGobbler.start();

try

{

p.waitFor();

}

catch (InterruptedException ie)

{

System.out.println(ie);

}

}

publicstaticclass

  StreamGobbler extends Thread {

  InputStream is;

String type;

public StreamGobbler(InputStream is, String type) {

this .is = is;

this .type = type;

}

publicvoid run() {

try {

InputStreamReader isr = new InputStreamReader(is);

BufferedReader br = new BufferedReader(isr);

String line = null ;

while ((line = br.readLine()) != null ) {

if (type.equals( "Error" )) {

System.out.println( "Error :" + line);

} else {

System.out.println( "Debug:" + line);

}

}

} catch (IOException ioe) {

ioe.printStackTrace();

}

}

}

}

begin

pro_jv_run_extpro( 'sqluldr264.exe scott/hh@pdborcl query="select * from emp" field=, head=yes file=D:\Desktop\tmp\sqluldr2\OUT2.TXT' );

pro_jv_run_extpro( '"D:\Program Files\WinRAR\Rar.exe" a -ep -df "D:\Desktop\tmp\sqluldr2\20160916.rar" "D:\Desktop\tmp\sqluldr2\OUT2.TXT"' );

end;