I have created Java class within Oracle but not sure how to create a function to return value. Any help would be appreciated.
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';