CREATE OR REPLACE AND COMPILE
JAVA SOURCE NAMED "Prs"
AS
 import  java.io.*;
 public   class  Prs{
     public   static   int  run_command(String vCmdName,String vType){
      try  {
       try  {
        int  nRetVal= 0 ;
       String vRes=vType.toString().trim().toUpperCase();
       Runtime r=Runtime.getRuntime();
       Process p=r.exec(vCmdName);;
         if  (!vRes.equals("WAIT")) {
            if  (!vRes.equals("NOWAIT"))
             return  - 20000 ;
        }
           if  (vRes.equals("WAIT")){
             p.waitFor();
             nRetVal=p.exitValue();
          }
            return  nRetVal;
      }  catch  (InterruptedException e){
           return  - 20003 ;
       }
     }  catch  (IOException e){
          return  - 20002 ;
       }
    }
}

create or replace function fr_test(sCmdName varchar2,sType varchar2)  return  number as
  language java
   name 'Prs.run_command(java.lang.String,java.lang.String)
return int';

select fr_test('cmd.exe', 'WAIT') from dual