oracle 调用java执行系统命令（linux环境）

create or replace and compile java source named runcmd as
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
public class RunCmd
{
    private static void copyStream(InputStream inputStream, OutputStream outStream,String type) throws IOException {
        byte[] bytes = new byte[1024];
        int len = 0;
        System.out.println("========"+type+"========");
        while ( (len = inputStream.read(bytes)) != -1)
         {
            System.out.println(new String(bytes,0,len));
            outStream.write(bytes,0,len);
        }
    }
    public static void exec(String cmd)
    {
     try {
            Process pc = Runtime.getRuntime().exec(cmd);
            copyStream(pc.getInputStream(), System.out,"InputStream()");
            copyStream(pc.getErrorStream(), System.out,"ErrorStream()");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
};

CREATE OR REPLACE PROCEDURE SP_RUNCMD
(cmd string)
as language java name 'RunCmd.exec(java.lang.String)';

begin
Dbms_Java.Grant_Permission('SCOTT', 'java.io.FilePermission', '<>', 'read ,write, execute, delete');
dbms_java.grant_permission('SCOTT','java.lang.RuntimePermission','*','writeFileDescriptor' );
end;

set serveroutput on;
call dbms_java.set_output(5000);
call sp_runcmd('/bin/sh -c /sbin/ifconfig');