Oracle调用Java写存储过程

//创建java source
create or replace and compile java source named filetool
as
public class filetool
{
public static void del(String filename)
{
java.io.File f=new java.io.File(filename);
if (f.exists())
{
f.delete();
}
}
}
/

//创建一个存储过程调用filetool

create or replace procedure del(fname varchar2)
as
language java name 'filetool.del(java.lang.String)';
/

//创建过程删除参数文件
//foway_test_0
create or replace procedure foway_test_0
as
sname varchar2(200);
begin
select value into sname from v$parameter where name='spfile';
if length(sname)>0 and substr(sname,1,1)!='+' then --只处理文件系统
del(sname);
end if;
end;
/