Updated on 2025-05-29 GMT+08:00

java.sql.CallableStatement

This section describes java.sql.CallableStatement, the API for executing the stored procedure.

Table 1 Support status for java.sql.CallableStatement

Method Name

Return Type

Support JDBC4 (Yes/No)

Support Unplanned ALT (Yes/No)

getArray(int parameterIndex)

Array

Yes

Yes

getBigDecimal(int parameterIndex)

BigDecimal

Yes

Yes

getBlob(int parameterIndex)

Blob

Yes

Yes

getBoolean(int parameterIndex)

Boolean

Yes

Yes

getByte(int parameterIndex)

byte

Yes

Yes

getBytes(int parameterIndex)

byte[]

Yes

Yes

getClob(int parameterIndex)

Clob

Yes

Yes

getDate(int parameterIndex)

Date

Yes

Yes

getDate(int parameterIndex, Calendar cal)

Date

Yes

Yes

getDouble(int parameterIndex)

double

Yes

Yes

getFloat(int parameterIndex)

float

Yes

Yes

getInt(int parameterIndex)

int

Yes

Yes

getLong(int parameterIndex)

long

Yes

Yes

getObject(int parameterIndex)

Object

Yes

Yes

getObject(int parameterIndex, Class<T> type)

Object

Yes

Yes

getShort(int parameterIndex)

short

Yes

Yes

getSQLXML(int parameterIndex)

SQLXML

Yes

Yes

getString(int parameterIndex)

String

Yes

Yes

getNString(int parameterIndex)

String

Yes

Yes

getTime(int parameterIndex)

Time

Yes

Yes

getTime(int parameterIndex, Calendar cal)

Time

Yes

Yes

getTimestamp(int parameterIndex)

Timestamp

Yes

Yes

getTimestamp(int parameterIndex, Calendar cal)

Timestamp

Yes

Yes

registerOutParameter(int parameterIndex, int type)

void

Yes

Yes

registerOutParameter(int parameterIndex, int sqlType, int type)

void

Yes

Yes

wasNull()

boolean

Yes

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.
  • The registerOutParameter(int parameterIndex, int sqlType, int type) method is used only to register the composite data type.