getting function value

[Guest_imported]

I have a function that returns 1 integer value but am having some problems getting it into my jsp page, here is what I have:

//Get Connection
...

CallableStatement NameCall = conn.prepareCall("{? = call tc_user.verify_user(?) }"
NameCall.setString(2, clock_nbr);
NameCall.registerOutParameter(1,java.sql.Types.INTEGER);
ResultSet rs = NameCall.execute();

while(rs.next()){
out.println("Tmp_Var "+rs.getInt(1)+ " "
}

%>


any help or sites with good examples would be appreciated