I am calling a stored procedure(Oracle 9.2.04) from
Java. My offshore team tested this code using stmt.registerOutParameter and it worked for them. Now at client site, it did not work. I changed it by setInt and it worked. Please let me know if it is a known bug.
============================================================
CallableStatement stmt=null;
try {
stmt= conn.prepareCall("call MoveToTemp(?)");
//stmt.registerOutParameter(1, Types.INTEGER, aiApplicationId);
stmt.setInt(1, aiApplicationId);
stmt.execute();
stmt.close();
} catch (Exception ex) {
ex.printStackTrace();
}
============================================================