Class TCallableStatement
TCallableStatement -> TPreparedStatement -> TStatement
Used to execute SQL stored procedures.
fetchOutParameters
Fetches the values of the output parameters.
|
registerDate index symbol
Register a variable to receive the value of an date output
parameter.
|
registerFloat index symbol
Register a variable to receive the value of an float output
parameter.
|
registerInt index symbol
Register a variable to receive the value of an integer output
parameter.
|
registerString index symbol
Register a variable to receive the value of astring output parameter.
|
|
fetchOutParameters
TCallableStatement fetchOutParameters
Fetches the values of the output parameters.
- Returns:
-
The same object for which this method was called.
-
Fetches the values of the output parameters. The variables registered
to receive the values of output parameters will be set with the
corresponding values.
This method is supposed to be called only after all the result
sets resulting from the stored procedure invocation have been
fetched with calls to
TStatement getResultSet.
registerDate
TCallableStatement registerDate index symbol
Register a variable to receive the value of an date output
parameter.
- Parameters:
- index -
The index of a parameter in the SQL statement that will be used
as an output parameter.
- symbol -
Symbol identifying a variable in the current context.
- Returns:
-
The same object for which this method was called.
-
Registers a variable that will receive the value of an
output parameter when the statement gets executed. The value will
be a TDate object. The variable
is identifyed by the
symbol argument. That
variable must alread be known in the current context.
registerFloat
TCallableStatement registerFloat index symbol
Register a variable to receive the value of an float output
parameter.
- Parameters:
- index -
The index of a parameter in the SQL statement that will be used
as an output parameter.
- symbol -
Symbol identifying a variable in the current context.
- Returns:
-
The same object for which this method was called.
-
Registers a variable that will receive the value of a
float parameter when the statement gets executed. The value will
be an floating point object. The variable
is identifyed by the
symbol argument. That
variable must alread exist in the current context.
registerInt
TCallableStatement registerInt index symbol
Register a variable to receive the value of an integer output
parameter.
- Parameters:
- index -
The index of a parameter in the SQL statement that will be used
as an output parameter.
- symbol -
Symbol identifying a variable in the current context.
- Returns:
-
The same object for which this method was called.
-
Registers a variable that will receive the value of an
output parameter when the statement gets executed. The value will
be an integer object. The variable
is identifyed by the
symbol argument. That
variable must alread be known in the current context.
registerString
TCallableStatement registerString index symbol
Register a variable to receive the value of astring output parameter.
- Parameters:
- index -
The index of a parameter in the SQL statement that will be used
as an output parameter.
- symbol -
Symbol identifying a variable in the current context.
- Returns:
-
The same object for which this method was called.
-
Registers a variable that will receive the value of an
output parameter when the statement gets executed. The value
will be a string object. The variable
is identifyed by the
symbol argument. That
variable must alread be known in the current context.
Report a bug or request new features
© 2009