在PL/SQL中執行作業系統命令

首先建立java source

createor replace and compile java source named execsyscmd as

import java.io.*;

publicclass ExecSysCmd

{

public static String exec_cmd(String args){

Runtime run = Runtime.getRuntime();

Process process = null;

try {

process = run.exec(args);

return "OK";

} catch (Exception e) {

return e.getMessage();

}

}

public static void main(String[] args)

{

System.out.println("No command linearguments");

}

}

/

其後建立函式呼叫該java soure

createor replace function exec_cmd(cmd string) return varchar2 is

language java name 'ExecSysCmd.exec_cmd(java.lang.String) returnjava.lang.String';

/

可以透過SQL查詢來呼叫

selectexec_cmd('d:\1.bat') from dual;

EXEC_CMD('D:\1.BAT')

-------------------------------------------------------------------

OK

也可以在PL/SQL程式碼中呼叫

setserveroutput on

declare

my_resultvarchar2(20);

begin

select exec_cmd('d:\1.bat') into my_resultfrom dual;

end;

/