项目里用到用java写oracle的存储过程，做个备份

create or replace and compile java source named "BinFileSave" as
package com.colin.test.bin1;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Date;

public class BinTest {
  public static String saveBinFile(String filename,oracle.sql.ARRAY p_in) {
  System.out.println(filename);
    String[] values = null;
    try {
      values = (String[])p_in.getArray();
    }catch (java.sql.SQLException e){
      e.printStackTrace();
    }
      n
        FileOutputStream out=null;
      try {
        out = new FileOutputStream(filename);
      } catch (FileNotFoundException e) {
        e.printStackTrace();
      }
        for (int i=0; i<values.length; i++){
          try {
          out.write(values[i].getBytes());
        } catch (IOException e) {
          e.printStackTrace();
        }
        }
        try {
        out.close();
      } catch (IOException e) {
        e.printStackTrace();
      }
      
      return '0';
    }
}

 第二步

create or replace function BinFileSave(filename in varchar2, p_in IN STRARRAY) return varchar2
as language java name
'com.colin.test.bin1.BinTest.saveBinFile(java.lang.String,oracle.sql.ARRAY) return java.lang.String';

 第三步

create type STRARRAY is table of varchar2(1000);

 第四部

set serveroutput on
declare 
v_a  strarray:=strarray('aaa','bbb');
a  varchar2(100);
begin
   a:=binfilesave('c:\\aa.log',v_a);
  -- for i in 1..v_a.count loop
  --    dbms_output.put_line(v_a(i));
   --end loop;
dbms_output.put_line(a);
end;