从Oracle函数调用Java函数
从Oracle函数调用Java函数
提问于 2018-06-14 03:45:47
我已经在Oracle中创建了Java类，但不确定如何创建函数来返回值。任何帮助都将不胜感激。
create or replace and compile java source named "ErrorMessage"
as
import java.util.zip.Inflater;
public class ErrorMessage {
public static String uncompressMessage(byte[] cdata, int uncompressedLength){
String uncompData2 = null;
try{
Inflater inflater = new Inflater();
inflater.setInput(cdata);
Byte [] uncompData = new byte[uncompressedLength];
int n = inflater.inflate(uncompData);
uncompData2 = uncompData.toString();
inflater.end();
}catch (Exception e){
e.getMessage();
}
return uncompData2;
}
}
create or replace
function getErrorMessage(msgdata blob, msgdatalength integer)
return varchar2
as language java
name 'ErrorMessage.uncompressMessage(byte[],int)
return java.lang.String';回答 1
Stack Overflow用户
回答已采纳
发布于 2018-06-14 04:24:47
类似于：
create or replace and compile java source named "ErrorMessage"
as
import java.util.zip.Inflater;
import java.lang.Byte;
import java.sql.Blob;
public class ErrorMessage {
public static String uncompressMessage( Blob data, int uncompressedLength ){
String uncompData2 = null;
try{
final long size = data.length();
final byte[] cdata = data.getBytes( 0L, (int) size );
Inflater inflater = new Inflater();
inflater.setInput( cdata );
byte[] uncompData = new byte[uncompressedLength];
int n = inflater.inflate(uncompData);
uncompData2 = new String( uncompData, "UTF-8" );
inflater.end();
}catch (Exception e){
e.getMessage();
}
return uncompData2;
}
}
/
create or replace function getErrorMessage(msgdata blob, msgdatalength number) return varchar2
as language java
name 'ErrorMessage.uncompressMessage(java.sql.Blob,int) return java.lang.String';页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/50845101
复制相关文章
相似问题