Registers the OUT parameter named
parameterName
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.
parameterName | the name of the parameter | |
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 parameterName does not correspond to a named
parameter; 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 or if the JDBC driver does not support
this method |
Types
Diagram: Statement