java class to run a exe file


CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "test" AS 
import java.io.IOException;
public class  test{
  public static void main(String[] args) throws Exception {
 
    p() ;
  }
  public static void p ()
  {
	  try{
	  Process p = Runtime.getRuntime().exec("rundll32 url.dll,FileProtocolHandler c:\\abc.pdf");
  }
	catch (IOException e)
	{
		e.printStackTrace();
	}  
  }
};
/

In order to call the Java stored procedure, a PL/SQL call specification must be published. 

CREATE OR REPLACE PROCEDURE b
AS LANGUAGE JAVA
NAME 'test.p()';
/


the following permissions granted:

BEGIN 
  DBMS_JAVA.grant_permission ('apex', 'java.io.FilePermission', 
                             '<<ALL FILES>>', 'read ,write, execute, delete');

  DBMS_JAVA.grant_permission ('apex', 'SYS:java.lang.RuntimePermission', 
                             'writeFileDescriptor', '');

  DBMS_JAVA.grant_permission ('apex', 'SYS:java.lang.RuntimePermission', 
                             'readFileDescriptor', ''); 
END; 
/

SET SERVEROUTPUT ON SIZE 1000000 
CALL DBMS_JAVA.SET_OUTPUT(1000000);
 
executing.............

BEGIN 
  b;
END;