I have a stored proc in Informix, which looks like this update_business_object(
String,Blob)
This is the code I have:
IfmxCallableStatement ifxCstmt = (IfmxCallableStatement)ifxCon.prepareCall(statement);
ifxCstmt.setString(1, "holidays");
ifxCstmt.setBlob(2, ifb);
IFB is a Ifx blob
try
{
ifxCstmt.execute();
if( DEBUG )
{
System.out.println("Binding of smart large object to table is done");
}
}
catch(SQLException se)
{
se.printStackTrace();
}
This throws a "Unable to resolve procedure" on the execute(). We know for sure that the signature is correct and the proc exists. Any ideas?