CallableStatement Object
- Last Updated: May 12, 2026
- 7 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
| CallableStatement Method | VersionIntroduced | Supported | Comments |
| Array getArray (int) | 2.0 Core | No | Throws “unsupported method” exception. |
| Array getArray (String) | 3.0 | No | Throws “unsupported method” exception. |
| Reader getCharacterStream(int) | 4.0 | Yes | |
| Reader getCharacterStream(String) | 4.0 | No | Throws “unsupported method” exception. |
| BigDecimal getBigDecimal (int) | 2.0 Core | Yes | |
| BigDecimal getBigDecimal (int, int) | 1.0 | Yes | |
| BigDecimal getBigDecimal (String) | 3.0 | No | Throws “unsupported method” exception. |
| Blob getBlob (int) | 2.0 Core | Yes | Not supported on servers which emulate this functionality over LONGVARBINARY. |
| Blob getBlob (String) | 3.0 | No | Throws “unsupported method” exception. |
| boolean execute () | 1.0 | Yes | |
| boolean execute (String) | 1.0 | No | Throws “invalid method call” exception. |
| boolean execute (String, int) | 3.0 | No | Throws “invalid method call” exception. |
| boolean execute (String, int[]) | 3.0 | No | Throws “invalid method call” exception. |
| boolean execute (String, String[]) | 3.0 | No | Throws “invalid method call” exception. |
| boolean getBoolean (int) | 1.0 | Yes | |
| boolean getBoolean (String) | 3.0 | No | Throws “unsupported method” exception. |
| boolean getMoreResults () | 1.0 | Yes | |
| boolean getMoreResults (int) | 3.0 | Yes | |
| boolean wasNull () | 1.0 | Yes | |
| byte [] getBytes (int) | 1.0 | Yes | |
| byte [] getBytes (String) | 3.0 | No | Throws “unsupported method” exception. |
| byte getByte (int) | 1.0 | Yes | |
| byte getByte (String) | 3.0 | No | Throws “unsupported method” exception. |
| Clob getClob (int) | 2.0 Core | Yes | Not supported on servers that emulate this functionality over LONGVARCHAR. |
| Clob getClob (String) | 3.0 | No | Throws “unsupported method” exception. |
| Connection getConnection () | 2.0 Core | Yes | |
| Date getDate (int) | 1.0 | Yes | |
| Date getDate (int, Calendar) | 2.0 Core | Yes | |
| Date getDate (String) | 3.0 | No | Throws “unsupported method” exception. |
| Date getDate (String, Calendar) | 3.0 | No | Throws “unsupported method” exception. |
| double getDouble (int) | 1.0 | Yes | |
| double getDouble (String) | 3.0 | No | Throws “unsupported method” exception. |
| float getFloat (int) | 1.0 | Yes | |
| float getFloat (String) | 3.0 | No | Throws “unsupported method” exception. |
| int [] executeBatch () | 2.0 Core | Yes | |
| int executeUpdate () | 1.0 | Yes | |
| int executeUpdate (String) | 1.0 | No | Throws “invalid method call” exception. |
| int executeUpdate (String, int) | 3.0 | No | Throws “invalid method call” exception. |
| int executeUpdate (String, int[]) | 3.0 | No | Throws “invalid method call” exception. |
| int executeUpdate (String, String[]) | 3.0 | No | Throws “invalid method call” exception. |
| int getFetchDirection () | 2.0 Core | Yes | |
| int getFetchSize () | 2.0 Core | Yes | |
| int getInt (int) | 1.0 | Yes | |
| int getInt (String) | 3.0 | No | Throws “unsupported method” exception. |
| int getMaxFieldSize () | 1.0 | Yes | |
| int getMaxRows () | 1.0 | Yes | |
| int getQueryTimeout () | 1.0 | Yes | Set the DataSourceQueryTimeOut service attribute to a value greater than 0. |
| int getResultSetConcurrency () | 2.0 Core | Yes | |
| int getResultSetHoldability () | 3.0 | No | Throws “unsupported method” exception. |
| int getResultSetType () | 2.0 Core | Yes | |
| int getUpdateCount () | 1.0 | Yes | |
| long getLong (int) | 1.0 | Yes | |
| long getLong (String) | 3.0 | No | Throws “unsupported method” exception. |
| Reader getNCharacterStream(int) | 4.0 | Yes | |
| Reader getNCharacterStream(String) | 4.0 | No | Throws “unsupported method” exception. |
| NClob getNClob(int) | 4.0 | Yes | |
| NClob getNClob(String) | 4.0 | No | Throws “unsupported method” exception. |
| String getNString(int) | 4.0 | Yes | |
| String getNString(String) | 4.0 | No | Throws “unsupported method” exception. |
| Object getObject (int) | 1.0 | Yes | |
| Object getObject (int, Map) | 2.0 Core | Yes | Map ignored. |
| Object getObject (String) | 3.0 | No | Throws “unsupported method” exception. |
| Object getObject (String, Map) | 3.0 | No | Throws “unsupported method” exception. |
| ParameterMetaData getParameterMetaData() | 3.0 | Yes | |
| Ref getRef (int) | 2.0 Core | No | Throws “unsupported method” exception. |
| Ref getRef (String) | 3.0 | No | Throws “unsupported method” exception. |
| ResultSet executeQuery () | 1.0 | Yes | |
| ResultSet executeQuery (String) | 1.0 | No | Throws “invalid method call” exception. |
| ResultSet getGeneratedKeys() | 3.0 | No | Throws “unsupported method” exception. |
| ResultSet getResultSet () | 1.0 | Yes | |
| ResultSetMetaData getMetaData () | 2.0 Core | Yes | |
| short getShort (int) | 1.0 | Yes | |
| short getShort (String) | 3.0 | No | Throws “unsupported method” exception. |
| SQLWarning getWarnings () | 1.0 | Yes | |
| SQLXML getSQLXML(int) | 4.0 | Yes | |
| SQLXML getSQLXML(String) | 4.0 | No | Throws “unsupported method” exception. |
| String getString (int) | 1.0 | Yes | |
| String getString (String) | 3.0 | No | Throws “unsupported method” exception. |
| Time getTime (int) | 1.0 | Yes | |
| Time getTime (int, Calendar) | 2.0 Core | Yes | |
| Time getTime (String) | 3.0 | No | Throws “unsupported method” exception. |
| Time getTime (String, Calendar) | 3.0 | No | Throws “unsupported method” exception. |
| Timestamp getTimestamp (int) | 1.0 | Yes | |
| Timestamp getTimestamp (int, Calendar) | 2.0 Core | Yes | |
| Timestamp getTimestamp (String) | 3.0 | No | Throws “unsupported method” exception. |
| Timestamp getTimestamp (String, Calendar) | 3.0 | No | Throws “unsupported method” exception. |
| URL getURL (int) | 3.0 | No | Throws “unsupported method” exception. |
| URL getURL (String) | 3.0 | No | Throws “unsupported method” exception. |
| boolean isWrapperFor(Class<?> iface) | 4.0 | Yes | |
| void addBatch () | 2.0 Core | Yes | |
| void addBatch (String) | 2.0 Core | No | Throws “invalid method call” exception. |
| void cancel () | 1.0 | Yes | Cancel can be used to cancel a function running synchronously on a statement, using a different thread. Whether Cancel will actually cancel the running function depends on the data store. |
| void clearBatch () | 2.0 Core | Yes | |
| void clearParameters () | 1.0 | Yes | |
| void clearWarnings () | 1.0 | Yes | |
| void close () | 1.0 | Yes | |
| void registerOutParameter (int, int) | 1.0 | Yes | This method should only be used against data stores supporting output or input-output parameters. |
| void registerOutParameter (int, int, int) | 1.0 | Yes | This method should only be used against data stores supporting output or input-output parameters. |
| void registerOutParameter (int, int, String) | 2.0 Core | Yes | String/typename ignored. This method should only be used against data stores supporting output or input-output parameters. |
| void registerOutParameter (String, int) | 3.0 | No | Throws “unsupported method” exception. |
| void registerOutParameter (String, int, int) | 3.0 | No | Throws “unsupported method” exception. |
| void registerOutParameter (String, int, String) | 3.0 | No | Throws “unsupported method” exception. |
| void setArray (int, Array) | 2.0 Core | No | Throws “unsupported method” exception. |
| void setAsciiStream(String, InputStream) | 4.0 | No | Throws “unsupported method” exception. |
| void setAsciiStream (int, InputStream, int) | 1.0 | Yes | |
| void setAsciiStream (String, InputStream, int) | 3.0 | No | Throws “unsupported method” exception. |
| void setAsciiStream(String, InputStream, long) | 4.0 | No | Throws “unsupported method” exception. |
| void setBigDecimal (int, BigDecimal) | 1.0 | Yes | |
| void setBigDecimal (String, BigDecimal) | 3.0 | No | Throws “unsupported method” exception. |
| void setBinaryStream(String, InputStream) | 4.0 | No | Throws “unsupported method” exception. |
| void setBinaryStream (int, InputStream, int) | 1.0 | Yes | |
| void setBinaryStream (String, InputStream, int) | 3.0 | No | Throws “unsupported method” exception. |
| void setBinaryStream(String, InputStream) | 4.0 | No | Throws “unsupported method” exception. |
| void setBlob(String, Blob) | 4.0 | No | Throws “unsupported method” exception. |
| void setBlob(String, InputStream) | 4.0 | No | Throws “unsupported method” exception. |
| void setBlob(String, InputStream, long) | 4.0 | No | Throws “unsupported method” exception. |
| void setBlob (int, Blob) | 2.0 Core | Yes | |
| void setBoolean (int, boolean) | 1.0 | Yes | |
| void setBoolean (String, boolean) | 3.0 | No | Throws “unsupported method” exception. |
| void setByte (int, byte) | 1.0 | Yes | |
| void setByte (String, byte) | 3.0 | No | Throws “unsupported method” exception. |
| void setBytes (int, byte []) | 1.0 | Yes | |
| void setBytes (String, byte []) | 3.0 | No | Throws “unsupported method” exception. |
| void setCharacterStream (int, Reader, int) | 2.0 Core | Yes | |
| void setCharacterStream (String, Reader, int) | 3.0 | No | Throws “unsupported method” exception. |
| void setCharacterStream(String, InputStream, long) | 4.0 | No | Throws “unsupported method” exception. |
| void setClob(String, Clob) | 4.0 | No | Throws “unsupported method” exception. |
| void setClob(String, Reader) | 4.0 | No | Throws “unsupported method” exception. |
| void setClob(String, Reader, long) | 4.0 | No | Throws “unsupported method” exception. |
| void setClob (int, Clob) | 2.0 Core | Yes | |
| void setCursorName (String) | 1.0 | No | Throws “unsupported method” exception. |
| void setDate (int, Date) | 1.0 | Yes | |
| void setDate (int, Date, Calendar) | 2.0 Core | Yes | |
| void setDate (String, Date) | 3.0 | No | Throws “unsupported method” exception. |
| void setDate (String, Date, Calendar) | 3.0 | No | Throws “unsupported method” exception. |
| void setDouble (int, double) | 1.0 | Yes | |
| void setDouble (String, double) | 3.0 | No | Throws “unsupported method” exception. |
| void setEscapeProcessing (boolean) | 1.0 | Yes | |
| void setFetchDirection (int) | 2.0 Core | Yes | OpenAccess SDK supports this method, but will ignore this hint provided by the application. |
| void setFetchSize (int) | 2.0 Core | Yes | OpenAccess SDK supports this method, but will ignore this hint provided by the application. |
| void setFloat (int, float) | 1.0 | Yes | |
| void setFloat (String, float) | 3.0 | No | Throws “unsupported method” exception. |
| void setInt (int, int) | 1.0 | Yes | |
| void setInt (String, int) | 3.0 | No | Throws “unsupported method” exception. |
| void setLong (int, long) | 1.0 | Yes | |
| void setLong (String, long) | 3.0 | No | Throws “unsupported method” exception. |
| void setMaxFieldSize (int) | 1.0 | Yes | |
| void setMaxRows (int) | 1.0 | Yes | |
| void setNCharacterStream(String, Reader, long) | 4.0 | No | Throws “unsupported method” exception. |
| void setNClob(String, NClob) | 4.0 | No | Throws “unsupported method” exception. |
| void setNClob(String, Reader) | 4.0 | No | Throws “unsupported method” exception. |
| void setNClob(String, Reader, long) | 4.0 | No | Throws “unsupported method” exception. |
| void setNString(String, String) | 4.0 | No | Throws “unsupported method” exception. |
| void setNull (int, int) | 1.0 | Yes | |
| void setNull (int, int, String) | 2.0 Core | Yes | OpenAccess SDK does not support the Advanced Data Type functionality. This method is always mapped to setNull (i, sqlType). |
| void setNull (String, int) | 3.0 | No | Throws “unsupported method” exception. |
| void setNull (String, int, String) | 3.0 | No | Throws “unsupported method” exception. |
| void setObject (int, Object) | 1.0 | Yes | |
| void setObject (int, Object, int) | 1.0 | Yes | |
| void setObject (int, Object, int, int) | 1.0 | Yes | |
| void setObject (String, Object) | 3.0 | No | Throws “unsupported method” exception. |
| void setObject (String, Object, int) | 3.0 | No | Throws “unsupported method” exception. |
| void setObject (String, Object, int, int) | 3.0 | No | Throws “unsupported method” exception. |
| void setQueryTimeout (int) | 1.0 | Yes | Set the DataSourceQueryTimeOut service attribute to a value greater than 0. Refer to the OpenAccess SDK Administrator’s Guide. |
| void setRef (int, Ref) | 2.0 Core | No | Throws “unsupported method” exception. |
| void setShort (int, short) | 1.0 | Yes | |
| void setShort (String, short) | 3.0 | No | Throws “unsupported method” exception. |
| void setSQLXML(String, SQLXML) | 4.0 | No | Throws “unsupported method” exception. |
| void setString (int, String) | 1.0 | Yes | |
| void setString (String, String) | 3.0 | No | Throws “unsupported method” exception. |
| void setTime (int, Time) | 1.0 | Yes | |
| void setTime (int, Time, Calendar) | 2.0 Core | Yes | |
| void setTime (String, Time) | 3.0 | No | Throws “unsupported method” exception. |
| void setTime (String, Time, Calendar) | 3.0 | No | Throws “unsupported method” exception. |
| void setTimestamp (int, Timestamp) | 1.0 | Yes | |
| void setTimestamp (int, Timestamp, Calendar) | 2.0 Core | Yes | |
| void setTimestamp (String, Timestamp) | 3.0 | No | Throws “unsupported method” exception. |
| void setTimestamp (String, Timestamp, Calendar) | 3.0 | No | Throws “unsupported method” exception. |
| void setUnicodeStream (int, InputStream, int) | 1.0 | Yes | Supported by OpenAccess SDK. This method has been deprecated in the JDBC 2.0 specification. |
| <T> T unwrap(Class<T> iface) | 4.0 | Yes | |
| void setURL (int, URL) | 3.0 | No | Throws “unsupported method” exception. |
| void setURL (String, URL) | 3.0 | No | Throws “unsupported method” exception. |