oracle存储过程中调用java

(以下内容只作个人笔记 ！) 

1:加载jar包

loadjava  -u xhy/xhy@xhy -r -f  D:/workspace/lib/commons-io-1.4.jar

--------------------------------------------------------

2:编写java sources

create or replace and compile java source named sp_exp_blobtostr as

package  util;

import  java.io.IOExcetion;

import  java.sql.SQLException;

import  sum.misc.BASE64Decoder;

import  sum.misc.BASE64Encoder;

public class OracleBlobToStr {

     static public String  ConvertBlobToString (java.sql.Blob BlobContent)

     {

byte[]       base64;

  String  newStr = "";

try{

base64 = org.apache.commons.io.IOUtils.toByteArray(BlobContent.getBinaryStream());

  newStr  = new BASE64Encode().encodeBuffer(base64);

}catch(IOException e)

{

e.printStackTrace(e);

}catch(IOException e)

{

e.printStackTrace();

}

     }

}

--------------------------------------------------------

3：编写调用java source 的函数

create or replace function p_exp_blobtostr(v_blob  in blob) return varchar2

---authid  current_user

as  language  java  name  'util.OracleBlobToStr.ConvertBlobToString(java.sql.Blob)  return java.lang.String' ;

--------------------------------------------------------