|
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
|
|