Registers the OUT parameter in ordinal position
parameterIndex
to the JDBC type
sqlType
. All OUT parameters must be registered
before a stored procedure is executed.
The JDBC type specified by sqlType
for an OUT
parameter determines the Java type that must be used
in the get
method to read the value of that parameter.
If the JDBC type expected to be returned to this output parameter
is specific to this particular database, sqlType
should be java.sql.Types.OTHER
. The method
getObject
retrieves the value.
parameterIndex | the first parameter is 1, the second is 2, and so on | |
sqlType | the JDBC type code defined by java.sql.Types .
If the parameter is of JDBC type NUMERIC
or DECIMAL , the version of
registerOutParameter that accepts a scale value
should be used. |
SQLException | if the parameterIndex is not valid;
if a database access error occurs or
this method is called on a closed CallableStatement | |
SQLFeatureNotSupportedException | if sqlType is
a ARRAY , BLOB , CLOB ,
DATALINK , JAVA_OBJECT , NCHAR ,
NCLOB , NVARCHAR , LONGNVARCHAR ,
REF , ROWID , SQLXML
or STRUCT data type and the JDBC driver does not support
this data type |
Types
Diagram: Statement