Overview Module Function Class Tea 3.2.5 Reference Documentation
© 2009 PDM&FC

Class TCallableStatement

TCallableStatement -> TPreparedStatement -> TStatement

Used to execute SQL stored procedures.

Method Summary
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.

Method Detail

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.


Overview Module Function Class Tea 3.2.5 Reference Documentation
© 2009 PDM&FC
Report a bug or request new features
© 2009