posted 19 years ago
Jeanne,
Thanks for sending me the link, I looked at the ex usage of Callable but it only has 1 OUT parameter. Correct my syntax if the stp is returning a return code.
CallableStatement cs =
con.prepareCall("{? = call accountlogin(?,?,?)}");
cs.registerOutParameter(1, Types.INTEGER) //return code
cs.setString(2,theuser);
cs.setString(3,password);
cs.registerOutParameter(4,Types.DATE);
cs.executeQuery();
int return_code = cs.getInt(1);
Date lastLogin = cs.getDate(4);
thanks,
ML
[ July 28, 2004: Message edited by: Martin Lira ]