I am making a function call to an oracle package/function that is returning a value. I am getting at the execute statement an UnsatisfiedLinkError on oracle.jdbc.oci8.OCIDBAccess.copy_value_from_binds(Native Method). I am using an 8i driver for Oracle 9i and have retreived the latest classes12 from Oracle (8i for 9i). getConfigValue just returns a
string.
My Code:
public String getSystemConfigInfo(String pConfigName){
String sTmp = "";
try{
String sql = "{? = call rts_utility.getConfigValue(?)}";
CallableStatement st = getConnection().prepareCall(sql);
st.setString(2, pConfigName);
st.registerOutParameter(1, Types.VARCHAR);
st.execute();
sTmp = st.getString(1);
st.close();//071706
}
catch(Exception ex){
//bury the error... just return ""
sTmp = "";
}
return sTmp;
}
Any assistance will be much appreciated.
Thank you,
Mary