callable statement

[ALaxmi Shankaran]

In callable statements what exactly registerOutParameter does?
e.g storedProc.registerOutParameter(1, java.sql.Types.VARCHAR);

[Gagan Gulati]

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.

-G

[Martin Lira]

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

  
     stmt.registerOutParameter(3, java.sql.Types.INTEGER);
     rs = stmt.executeQuery();
     while(rs.next){
     //do something...
     }
     // to print the OUT value
     System.out.println("Registered users = "+ stmt.getInt(3));

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 ]