As you are using callable statements over a Stored proc. That stored proc might return some parameters. To get these parameters in your Java variables, you have to first register these parameters.
You might need to register a parameter when your stored procedure (stp)returns you some values. Example: There is a stp called GetNoOfRegisteredUsers{1,2,3}
1 and 2 = IN Parameter like user id and dob 3 = OUT parameter of type java.sql.INTEGER
So you will have to write it like this
Note: If your stored procedure returns a ResultSet it should be read first before doing a stmt.getInt(3). As doing this implicitly closes the ResultSet.
Martin
[ August 19, 2004: Message edited by: Martin Lira ]
[ August 19, 2004: Message edited by: Martin Lira ] [ August 19, 2004: Message edited by: Martin Lira ]
Your buns are mine! But you can have this tiny ad:
a bit of art, as a gift, that will fit in a stocking