PL/SQL java存储过程

1.创建java存储过程

create or replace and compile java source named "MyFile" as
import java.io.*;

public class MyFile{
	public static void remove(String filename) {
		File file = new File(filename);
		System.out.println("Deleting....." + filename);
		try {
			boolean b = file.delete();

		}
		catch ( Exception e){
			System.out.println("Exception");
                        e.printStackTrace();
		}

	}
}
/

2.创建存储过程，调用MyFile的removefile方法

 create or replace procedure deletefile(filename in varchar2)
 as
 language java name 'MyFile.remove(java.lang.String)';
/

3.给要调用这个用户赋予相应的权限

 conn / as sysdba
 exec dbms_java.grant_permission('SCOTT','SYS:java.io.FilePermission','f:/test/*','delete');

4.scott用户使用deletefile这个存储过程。

 conn scott/tiger
 exce deletefile("f:/test/test.txt");