用oracle調用java來創建文件夾

1、創建Java源代碼：

create or replace and compile java source named optionfiler as import java.text.SimpleDateFormat; import java.util.Calendar; public class OptionFiler { public static String createFolder(String filePath) { if (filePath == null || filePath.equals("")) return "No value for file path"; java.io.File myFilePath = null; try { filePath = filePath.toString(); myFilePath = new java.io.File(filePath); if (!myFilePath.exists()) { myFilePath.mkdir(); } return "OK"; }catch (Exception e) { return e.getMessage(); } } };

 

2、創建Function來調用java：

create or replace function folderfunc(filepath varchar2) return varchar2
as language java
name 'OptionFiler.createFolder(java.lang.String) return java.lang.String';

 

3、授予用戶的讀寫權限：

begin
dbms_java.grant_permission( 'HR', 'SYS:java.io.FilePermission', '/u02/backups/-', 'read' );
dbms_java.grant_permission( 'HR', 'SYS:java.io.FilePermission', '/u02/backups/-', 'write' );
end;

 

4、測試

declare
  retval varchar2(400);
begin
 retval := folderfunc('/u02/backups/2011');
 DBMS_OUTPUT.PUT_LINE(retval);
end;