ICallableStatement Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
The interface used to execute SQL stored procedures.
[Android.Runtime.Register("java/sql/CallableStatement", "", "Java.Sql.ICallableStatementInvoker")]
public interface ICallableStatement : IDisposable, Java.Interop.IJavaPeerable, Java.Sql.IPreparedStatement
[<Android.Runtime.Register("java/sql/CallableStatement", "", "Java.Sql.ICallableStatementInvoker")>]
type ICallableStatement = interface
interface IPreparedStatement
interface IStatement
interface IWrapper
interface IJavaObject
interface IDisposable
interface IJavaPeerable
- Attributes
- Implements
Remarks
The interface used to execute SQL stored procedures. The JDBC API provides a stored procedure SQL escape syntax that allows stored procedures to be called in a standard way for all RDBMSs. This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. The other parameters can be used for input, output or both. Parameters are referred to sequentially, by number, with the first parameter being 1.
{?= call <procedure-name>[(<arg1>,<arg2>, ...)]}
{call <procedure-name>[(<arg1>,<arg2>, ...)]}
IN parameter values are set using the set
methods inherited from PreparedStatement
. The type of all OUT parameters must be registered prior to executing the stored procedure; their values are retrieved after execution via the get
methods provided here.
A CallableStatement
can return one ResultSet
object or multiple ResultSet
objects. Multiple ResultSet
objects are handled using operations inherited from Statement
.
For maximum portability, a call's ResultSet
objects and update counts should be processed prior to getting the values of output parameters.
Java documentation for java.sql.CallableStatement
.
Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.
Fields
CloseAllResults |
The constant indicating that all |
CloseCurrentResult |
The constant indicating that the current |
ExecuteFailed |
The constant indicating that an error occured while executing a batch statement. (Inherited from IStatement) |
KeepCurrentResult |
The constant indicating that the current |
NoGeneratedKeys |
The constant indicating that generated keys should not be made available for retrieval. (Inherited from IStatement) |
ReturnGeneratedKeys |
The constant indicating that generated keys should be made available for retrieval. (Inherited from IStatement) |
SuccessNoInfo |
The constant indicating that a batch statement executed successfully but that no count of the number of rows it affected is available. (Inherited from IStatement) |
Properties
Connection |
Gets the |
FetchDirection |
Gets the default direction for fetching rows for |
FetchSize |
Gets the default number of rows for a fetch for the |
GeneratedKeys |
Returns auto generated keys created by executing this statement. (Inherited from IStatement) |
Handle |
Gets the JNI value of the underlying Android object. (Inherited from IJavaObject) |
IsClosed |
Returns true if this statement has been closed, false otherwise. (Inherited from IStatement) |
JniIdentityHashCode |
Returns the value of |
JniManagedPeerState |
State of the managed peer. (Inherited from IJavaPeerable) |
JniPeerMembers |
Member access and invocation support. (Inherited from IJavaPeerable) |
MaxFieldSize |
Gets the maximum number of bytes which can be returned as values from
character and binary type columns in a |
MaxRows |
Gets the maximum number of rows that a |
MetaData |
Returns a |
MoreResults |
Moves to this statement's next result. (Inherited from IStatement) |
ParameterMetaData |
Gets information about the parameters of the |
PeerReference |
Returns a JniObjectReference of the wrapped Java object instance. (Inherited from IJavaPeerable) |
Poolable |
Returns true if this statement is poolable, false otherwise. (Inherited from IStatement) |
QueryTimeout |
Gets the timeout value for the statement's execution time. (Inherited from IStatement) |
ResultSet |
Gets the current result. (Inherited from IStatement) |
ResultSetConcurrency |
Gets the concurrency setting for |
ResultSetHoldability |
Gets the cursor hold setting for |
ResultSetType |
Gets the |
UpdateCount |
Gets an update count for the current result if it is not a |
Warnings |
Retrieves the first |
Methods
AddBatch() |
Adds a set of parameters to this |
AddBatch(String) |
Adds the given SQL command to the current list of commmands for this
|
Cancel() |
Cancels this |
ClearBatch() |
Empties this |
ClearParameters() |
Clears the current parameter values immediately. (Inherited from IPreparedStatement) |
ClearWarnings() |
Clears all the warnings reported on this |
Close() |
Releases this |
Disposed() |
Called when the instance has been disposed. (Inherited from IJavaPeerable) |
DisposeUnlessReferenced() |
If there are no outstanding references to this instance, then
calls |
Execute() |
Executes the SQL statement in this |
Execute(String) |
Executes the given SQL statement, which may return multiple results. (Inherited from IStatement) |
Execute(String, Int32) |
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval. (Inherited from IStatement) |
Execute(String, Int32[]) |
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. (Inherited from IStatement) |
Execute(String, String[]) |
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. (Inherited from IStatement) |
ExecuteBatch() |
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. (Inherited from IStatement) |
ExecuteQuery() |
Executes the SQL query in this |
ExecuteQuery(String) |
Executes the given SQL statement, which returns a single
|
ExecuteUpdate() |
Executes the SQL statement in this |
ExecuteUpdate(String) |
Executes the given SQL statement, which may be an |
ExecuteUpdate(String, Int32) |
Executes the given SQL statement and signals the driver with the
given flag about whether the
auto-generated keys produced by this |
ExecuteUpdate(String, Int32[]) |
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. (Inherited from IStatement) |
ExecuteUpdate(String, String[]) |
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. (Inherited from IStatement) |
Finalized() |
Called when the instance has been finalized. (Inherited from IJavaPeerable) |
GetArray(Int32) |
Retrieves the value of the designated JDBC |
GetArray(String) |
Retrieves the value of a JDBC |
GetBigDecimal(Int32) |
Retrieves the value of the designated JDBC |
GetBigDecimal(Int32, Int32) |
Obsolete.
Retrieves the value of the designated JDBC |
GetBigDecimal(String) |
Retrieves the value of a JDBC |
GetBlob(Int32) |
Retrieves the value of the designated JDBC |
GetBlob(String) |
Retrieves the value of a JDBC |
GetBoolean(Int32) |
Retrieves the value of the designated JDBC |
GetBoolean(String) |
Retrieves the value of a JDBC |
GetByte(Int32) |
Retrieves the value of the designated JDBC |
GetByte(String) |
Retrieves the value of a JDBC |
GetBytes(Int32) |
Retrieves the value of the designated JDBC |
GetBytes(String) |
Retrieves the value of a JDBC |
GetCharacterStream(Int32) |
Retrieves the value of the designated parameter as a
|
GetCharacterStream(String) |
Retrieves the value of the designated parameter as a
|
GetClob(Int32) |
Retrieves the value of the designated JDBC |
GetClob(String) |
Retrieves the value of a JDBC |
GetDate(Int32) |
Retrieves the value of the designated JDBC |
GetDate(Int32, Calendar) |
Retrieves the value of the designated JDBC |
GetDate(String) |
Retrieves the value of a JDBC |
GetDate(String, Calendar) |
Retrieves the value of a JDBC |
GetDouble(Int32) |
Retrieves the value of the designated JDBC |
GetDouble(String) |
Retrieves the value of a JDBC |
GetFloat(Int32) |
Retrieves the value of the designated JDBC |
GetFloat(String) |
Retrieves the value of a JDBC |
GetInt(Int32) |
Retrieves the value of the designated JDBC |
GetInt(String) |
Retrieves the value of a JDBC |
GetLong(Int32) |
Retrieves the value of the designated JDBC |
GetLong(String) |
Retrieves the value of a JDBC |
GetMoreResults(Int32) |
Moves to this |
GetNCharacterStream(Int32) |
Retrieves the value of the designated parameter as a
|
GetNCharacterStream(String) |
Retrieves the value of the designated parameter as a
|
GetNClob(Int32) |
Retrieves the value of the designated JDBC |
GetNClob(String) |
Retrieves the value of a JDBC |
GetNString(Int32) |
Retrieves the value of the designated |
GetNString(String) |
Retrieves the value of the designated |
GetObject(Int32) |
Retrieves the value of the designated parameter as an |
GetObject(Int32, IDictionary<String,Class>) |
Returns an object representing the value of OUT parameter
|
GetObject(String) |
Retrieves the value of a parameter as an |
GetObject(String, IDictionary<String,Class>) |
Returns an object representing the value of OUT parameter
|
GetRef(Int32) |
Retrieves the value of the designated JDBC |
GetRef(String) |
Retrieves the value of a JDBC |
GetRowId(Int32) |
Retrieves the value of the designated JDBC |
GetRowId(String) |
Retrieves the value of the designated JDBC |
GetShort(Int32) |
Retrieves the value of the designated JDBC |
GetShort(String) |
Retrieves the value of a JDBC |
GetSQLXML(Int32) |
Retrieves the value of the designated |
GetSQLXML(String) |
Retrieves the value of the designated |
GetString(Int32) |
Retrieves the value of the designated JDBC |
GetString(String) |
Retrieves the value of a JDBC |
GetTime(Int32) |
Retrieves the value of the designated JDBC |
GetTime(Int32, Calendar) |
Retrieves the value of the designated JDBC |
GetTime(String) |
Retrieves the value of a JDBC |
GetTime(String, Calendar) |
Retrieves the value of a JDBC |
GetTimestamp(Int32) |
Retrieves the value of the designated JDBC |
GetTimestamp(Int32, Calendar) |
Retrieves the value of the designated JDBC |
GetTimestamp(String) |
Retrieves the value of a JDBC |
GetTimestamp(String, Calendar) |
Retrieves the value of a JDBC |
GetURL(Int32) |
Retrieves the value of the designated JDBC |
GetURL(String) |
Retrieves the value of a JDBC |
IsWrapperFor(Class) |
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. (Inherited from IWrapper) |
RegisterOutParameter(Int32, Int32) |
Registers the OUT parameter in ordinal position
|
RegisterOutParameter(Int32, Int32, Int32) |
Registers the parameter in ordinal position
|
RegisterOutParameter(Int32, Int32, String) |
Registers the designated output parameter. |
RegisterOutParameter(String, Int32) |
Registers the OUT parameter named
|
RegisterOutParameter(String, Int32, Int32) |
Registers the parameter named
|
RegisterOutParameter(String, Int32, String) |
Registers the designated output parameter. |
SetArray(Int32, IArray) |
Sets the designated parameter to the given |
SetAsciiStream(Int32, Stream) |
Sets the designated parameter to the given input stream. (Inherited from IPreparedStatement) |
SetAsciiStream(Int32, Stream, Int32) |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. (Inherited from IPreparedStatement) |
SetAsciiStream(Int32, Stream, Int64) |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. (Inherited from IPreparedStatement) |
SetAsciiStream(String, Stream) |
Sets the designated parameter to the given input stream. |
SetAsciiStream(String, Stream, Int32) |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
SetAsciiStream(String, Stream, Int64) |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
SetBigDecimal(Int32, BigDecimal) |
Sets the designated parameter to the given |
SetBigDecimal(String, BigDecimal) |
Sets the designated parameter to the given
|
SetBinaryStream(Int32, Stream) |
Sets the designated parameter to the given input stream. (Inherited from IPreparedStatement) |
SetBinaryStream(Int32, Stream, Int32) |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. (Inherited from IPreparedStatement) |
SetBinaryStream(Int32, Stream, Int64) |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. (Inherited from IPreparedStatement) |
SetBinaryStream(String, Stream) |
Sets the designated parameter to the given input stream. |
SetBinaryStream(String, Stream, Int32) |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
SetBinaryStream(String, Stream, Int64) |
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
SetBlob(Int32, IBlob) |
Sets the designated parameter to the given |
SetBlob(Int32, Stream) |
Sets the designated parameter to a |
SetBlob(Int32, Stream, Int64) |
Sets the designated parameter to a |
SetBlob(String, IBlob) |
Sets the designated parameter to the given |
SetBlob(String, Stream) |
Sets the designated parameter to a |
SetBlob(String, Stream, Int64) |
Sets the designated parameter to a |
SetBoolean(Int32, Boolean) |
Sets the designated parameter to the given Java |
SetBoolean(String, Boolean) |
Sets the designated parameter to the given Java |
SetByte(Int32, SByte) |
Sets the designated parameter to the given Java |
SetByte(String, SByte) |
Sets the designated parameter to the given Java |
SetBytes(Int32, Byte[]) |
Sets the designated parameter to the given Java array of bytes. (Inherited from IPreparedStatement) |
SetBytes(String, Byte[]) |
Sets the designated parameter to the given Java array of bytes. |
SetCharacterStream(Int32, Reader) |
Sets the designated parameter to the given |
SetCharacterStream(Int32, Reader, Int32) |
Sets the designated parameter to the given |
SetCharacterStream(Int32, Reader, Int64) |
Sets the designated parameter to the given |
SetCharacterStream(String, Reader) |
Sets the designated parameter to the given |
SetCharacterStream(String, Reader, Int32) |
Sets the designated parameter to the given |
SetCharacterStream(String, Reader, Int64) |
Sets the designated parameter to the given |
SetClob(Int32, IClob) |
Sets the designated parameter to the given |
SetClob(Int32, Reader) |
Sets the designated parameter to a |
SetClob(Int32, Reader, Int64) |
Sets the designated parameter to a |
SetClob(String, IClob) |
Sets the designated parameter to the given |
SetClob(String, Reader) |
Sets the designated parameter to a |
SetClob(String, Reader, Int64) |
Sets the designated parameter to a |
SetCursorName(String) |
Sets the SQL cursor name to the given |
SetDate(Int32, Date) |
Sets the designated parameter to the given |
SetDate(Int32, Date, Calendar) |
Sets the designated parameter to the given |
SetDate(String, Date) |
Sets the designated parameter to the given |
SetDate(String, Date, Calendar) |
Sets the designated parameter to the given |
SetDouble(Int32, Double) |
Sets the designated parameter to the given Java |
SetDouble(String, Double) |
Sets the designated parameter to the given Java |
SetEscapeProcessing(Boolean) |
Sets escape processing on or off. (Inherited from IStatement) |
SetFloat(Int32, Single) |
Sets the designated parameter to the given Java |
SetFloat(String, Single) |
Sets the designated parameter to the given Java |
SetInt(Int32, Int32) |
Sets the designated parameter to the given Java |
SetInt(String, Int32) |
Sets the designated parameter to the given Java |
SetJniIdentityHashCode(Int32) |
Set the value returned by |
SetJniManagedPeerState(JniManagedPeerStates) | (Inherited from IJavaPeerable) |
SetLong(Int32, Int64) |
Sets the designated parameter to the given Java |
SetLong(String, Int64) |
Sets the designated parameter to the given Java |
SetNCharacterStream(Int32, Reader) |
Sets the designated parameter to a |
SetNCharacterStream(Int32, Reader, Int64) |
Sets the designated parameter to a |
SetNCharacterStream(String, Reader) |
Sets the designated parameter to a |
SetNCharacterStream(String, Reader, Int64) |
Sets the designated parameter to a |
SetNClob(Int32, INClob) |
Sets the designated parameter to a |
SetNClob(Int32, Reader) |
Sets the designated parameter to a |
SetNClob(Int32, Reader, Int64) |
Sets the designated parameter to a |
SetNClob(String, INClob) |
Sets the designated parameter to a |
SetNClob(String, Reader) |
Sets the designated parameter to a |
SetNClob(String, Reader, Int64) |
Sets the designated parameter to a |
SetNString(Int32, String) |
Sets the designated paramter to the given |
SetNString(String, String) |
Sets the designated parameter to the given |
SetNull(Int32, Int32) |
Sets the designated parameter to SQL |
SetNull(Int32, Int32, String) |
Sets the designated parameter to SQL |
SetNull(String, Int32) |
Sets the designated parameter to SQL |
SetNull(String, Int32, String) |
Sets the designated parameter to SQL |
SetObject(Int32, Object) |
Sets the value of the designated parameter using the given object. (Inherited from IPreparedStatement) |
SetObject(Int32, Object, Int32) |
Sets the value of the designated parameter with the given object. (Inherited from IPreparedStatement) |
SetObject(Int32, Object, Int32, Int32) |
Sets the value of the designated parameter with the given object. (Inherited from IPreparedStatement) |
SetObject(String, Object) |
Sets the value of the designated parameter with the given object. |
SetObject(String, Object, Int32) |
Sets the value of the designated parameter with the given object. |
SetObject(String, Object, Int32, Int32) |
Sets the value of the designated parameter with the given object. |
SetPeerReference(JniObjectReference) |
Set the value returned by |
SetRef(Int32, IRef) |
Sets the designated parameter to the given
|
SetRowId(Int32, IRowId) |
Sets the designated parameter to the given |
SetRowId(String, IRowId) |
Sets the designated parameter to the given |
SetShort(Int32, Int16) |
Sets the designated parameter to the given Java |
SetShort(String, Int16) |
Sets the designated parameter to the given Java |
SetSQLXML(Int32, ISQLXML) |
Sets the designated parameter to the given |
SetSQLXML(String, ISQLXML) |
Sets the designated parameter to the given |
SetString(Int32, String) |
Sets the designated parameter to the given Java |
SetString(String, String) |
Sets the designated parameter to the given Java |
SetTime(Int32, Time) |
Sets the designated parameter to the given |
SetTime(Int32, Time, Calendar) |
Sets the designated parameter to the given |
SetTime(String, Time) |
Sets the designated parameter to the given |
SetTime(String, Time, Calendar) |
Sets the designated parameter to the given |
SetTimestamp(Int32, Timestamp) |
Sets the designated parameter to the given |
SetTimestamp(Int32, Timestamp, Calendar) |
Sets the designated parameter to the given |
SetTimestamp(String, Timestamp) |
Sets the designated parameter to the given |
SetTimestamp(String, Timestamp, Calendar) |
Sets the designated parameter to the given |
SetUnicodeStream(Int32, Stream, Int32) |
Obsolete.
Sets the designated parameter to the given input stream, which will have the specified number of bytes. (Inherited from IPreparedStatement) |
SetURL(Int32, URL) |
Sets the designated parameter to the given |
SetURL(String, URL) |
Sets the designated parameter to the given |
UnregisterFromRuntime() |
Unregister this instance so that the runtime will not return it from future Java.Interop.JniRuntime+JniValueManager.PeekValue invocations. (Inherited from IJavaPeerable) |
Unwrap(Class) |
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. (Inherited from IWrapper) |
WasNull() |
Retrieves whether the last OUT parameter read had the value of
SQL |
Extension Methods
JavaCast<TResult>(IJavaObject) |
Performs an Android runtime-checked type conversion. |
JavaCast<TResult>(IJavaObject) | |
GetJniTypeName(IJavaPeerable) |