In order to get the results from a stored procedure call, you must register any OUT or IN OUT
parameters before executing the CallableStatement. To do this, call the
CallableStatement object's registerOutParameter( ) method, passing it the position of
the placeholder character in the callable-statement
string starting at 1 and moving from left to
right, just as you do for the other accessor methods, and a java.sql.Types constant to specify
the SQL data type that will be returned. There are two applicable signatures for the
registerOutParameter( ) method. For VARCHAR2 and DATE parameters, use the
following signature:
registerOutParameter(
int parameterIndex,
int sqlType)
throws SQLException
(Java Programming with Oracle
JDBC ISBN: 0-596-00088-x, 496 pages)