skip to main content
JDBC support : Supported Functionality : CallableStatement
  

Try DataDirect Drivers Now

CallableStatement

CallableStatement Methods
Version Introduced
Supported
Comments
Array getArray(int)
2.0 Core
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
The Progress OpenEdge driver throws an "unsupported method" exception.
Array getArray(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw an "unsupported method" exception.
Reader getCharacterStream(int)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
Reader getCharacterStream(String)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
BigDecimal getBigDecimal(int)
2.0 Core
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
BigDecimal getBigDecimal(int, int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
BigDecimal getBigDecimal(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
Blob getBlob(int)
2.0 Core
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
All other drivers support using data types that map to the JDBC LONGVARBINARY data type.
Blob getBlob(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
boolean getBoolean(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
boolean getBoolean(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
byte getByte(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
byte getByte(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
byte [] getBytes(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
byte [] getBytes(String)
3.0
Yes
Supported for the SQL Server driver only. All other drivers throw "unsupported method" exception.
Clob getClob(int)
2.0 Core
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
All other drivers support using data types that map to the JDBC LONGVARBINARY data type.
Clob getClob(String)
3.0
Yes
Supported for the SQL Server driver only using with data types that map to the JDBC LONGVARCHAR data type.
All other drivers throw "unsupported method" exception.
Date getDate(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
Date getDate(int, Calendar)
2.0 Core
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
Date getDate(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
Date getDate(String, Calendar)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
double getDouble(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
double getDouble(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
float getFloat(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
float getFloat(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
int getInt(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
int getInt(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
long getLong(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
long getLong(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
Reader getNCharacterStream(int)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
Reader getNCharacterStream(String)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
NClob getNClob(int)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
NClob getNClob(String)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
String getNString(int)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw "unsupported method" exception.
String getNString(String)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
Object getObject(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
Object getObject(int, Map)
2.0 Core
Yes
The drivers ignore the Map argument.
Object getObject(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
Object getObject(String, Map)
3.0
Yes
Supported for the SQL Server driver only. The SQL Server driver ignores the Map argument.
All other drivers throw "unsupported method" exception.
Ref getRef(int)
2.0 Core
No
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
All other drivers throw "unsupported method" exception.
Ref getRef(String)
3.0
No
The drivers throw "unsupported method" exception.
short getShort(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
short getShort(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
SQLXML getSQLXML(int)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
SQLXML getSQLXML(String)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
String getString(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
String getString(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
Time getTime(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
Time getTime(int, Calendar)
2.0 Core
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
Time getTime(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
Time getTime(String, Calendar)
3.0
Yes
Supported for SQL Server driver only.
All other drivers throw "unsupported method" exception.
Timestamp getTimestamp(int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
Timestamp getTimestamp(int, Calendar)
2.0 Core
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
Timestamp getTimestamp(String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
Timestamp getTimestamp(String, Calendar)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
URL getURL(int)
3.0
No
The drivers throw "unsupported method" exception.
URL getURL(String)
3.0
No
The drivers throw "unsupported method" exception.
boolean isWrapperFor(Class<?> iface)
4.0
Yes
void registerOutParameter(int, int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
void registerOutParameter(int, int, int)
1.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
void registerOutParameter(int, int, String)
2.0 Core
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
The Oracle driver supports the String argument.
For all other drivers, the String argument is ignored.
void registerOutParameter(String, int)
3.0
Yes
Supported for the SQL Server driver only.
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
All other drivers throw "unsupported method" exception.
void registerOutParameter(String, int, int)
3.0
Yes
Supported for the SQL Server driver only.
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
All other drivers throw "unsupported method" exception.
void registerOutParameter(String, int, String)
3.0
Yes
Supported for the SQL Server driver only.
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "invalid parameter bindings" exception when your application calls output parameters.
All other drivers throw "unsupported method" exception. String/typename ignored.
void setArray(int, Array)
2.0 Core
Yes
Supported for the Oracle driver only.
All other drivers throw "unsupported method" exception.
void setAsciiStream(String, InputStream)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setAsciiStream(String, InputStream, int)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setAsciiStream(String, InputStream, long)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setBigDecimal(String, BigDecimal)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setBinaryStream(String, InputStream)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setBinaryStream(String, InputStream, int)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setBinaryStream(String, InputStream, long)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setBlob(String, Blob)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setBlob(String, InputStream)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setBlob(String, InputStream, long)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setBoolean(String, boolean)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setByte(String, byte)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setBytes(String, byte [])
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setCharacterStream(String, Reader, int)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setCharacterStream(String, InputStream, long)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setClob(String, Clob)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setClob(String, Reader)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setClob(String, Reader, long)
4.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setDate(String, Date)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setDate(String, Date, Calendar)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setDouble(String, double)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setFloat(String, float)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setInt(String, int)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setLong(String, long)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setNCharacterStream(String, Reader, long)
4.0
Yes
void setNClob(String, NClob)
4.0
Yes
void setNClob(String, Reader)
4.0
Yes
void setNClob(String, Reader, long)
4.0
Yes
void setNString(String, String)
4.0
Yes
void setNull(int, int, String)
2.0 Core
Yes
void setNull(String, int)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setNull(String, int, String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setObject(String, Object)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setObject(String, Object, int)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setObject(String, Object, int, int)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setShort(String, short)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setSQLXML(String, SQLXML)
4.0
Yes
The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce throw an "unsupported method" exception.
void setString(String, String)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setTime(String, Time)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setTime(String, Time, Calendar)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setTimestamp(String, Timestamp)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
void setTimestamp(String, Timestamp, Calendar)
3.0
Yes
Supported for the SQL Server driver only.
All other drivers throw "unsupported method" exception.
<T> T unwrap(Class<T> iface)
4.0
Yes
void setURL(String, URL)
3.0
No
The drivers throw "unsupported method" exception.
boolean wasNull()
1.0
Yes