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

需求

Oracle調用第三方外部程序。Oracle使用sqluldr2快速導出大批量數據，然後用winrar壓縮後發送郵件。

源碼

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(); 

} 

} 

} 

} 

 

存儲過程

create or replace procedure pro_jv_run_extpro(p_cmd varchar2) as

language java name 'jv_run_extpro.run(java.lang.String)';

調用

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; 

總結

Java source裡StreamGobbler這個類不能少，用於異步讀取命令的輸出。

以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持。