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();

}

return   newStr;

     }

 

}

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

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' ;

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