Help Center > > Developer Guide> Tutorial: Development Using JDBC or ODBC> JDBC Interface Reference> java.sql.CallableStatement

java.sql.CallableStatement

Updated at: Jul 15, 2020 GMT+08:00

This section describes java.sql.CallableStatement, the stored procedure execution interface.

Table 1 Support status for java.sql.CallableStatement

Method Name

Return Type

Support JDBC 4

registerOutParameter(int parameterIndex, int type)

void

Yes

wasNull()

Boolean

Yes

getString(int parameterIndex)

String

Yes

getBoolean(int parameterIndex)

Boolean

Yes

getByte(int parameterIndex)

byte

Yes

getShort(int parameterIndex)

short

Yes

getInt(int parameterIndex)

int

Yes

getLong(int parameterIndex)

long

Yes

getFloat(int parameterIndex)

float

Yes

getDouble(int parameterIndex)

double

Yes

getBigDecimal(int parameterIndex)

BigDecimal

Yes

getBytes(int parameterIndex)

byte[]

Yes

getDate(int parameterIndex)

Date

Yes

getTime(int parameterIndex)

Time

Yes

getTimestamp(int parameterIndex)

Timestamp

Yes

getObject(int parameterIndex)

Object

Yes

  • The batch operation of statements containing OUT parameter is not allowed.
  • The following methods are inherited from java.sql.Statement: close, execute, executeQuery, executeUpdate, getConnection, getResultSet, getUpdateCount, isClosed, setMaxRows, and setFetchSize.
  • The following methods are inherited from java.sql.PreparedStatement: addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, setBigDecimal, setBoolean, setByte, setBytes, setDate, setDouble, setFloat, setInt, setLong, setNull, setObject, setString, setTime, and setTimestamp.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel