#include <SQLSelectRow.hh>
Inherited by fatalmind::oracle::SQLSelectRow< TM, SLMDC >.
Public Member Functions | |
virtual void | bindout (const unsigned int pos, char &val, bool &isnull=BindOutInterface::notnullconstant) |
Specify where the output data of an select statement are to be stored. | |
virtual void | bindout (const unsigned int pos, signed char &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, unsigned char &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, short int &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, unsigned short int &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, int &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, unsigned int &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, long int &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, unsigned long int &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, float &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, double &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, long double &val, bool &isnull=BindOutInterface::notnullconstant) |
virtual void | bindout (const unsigned int pos, std::string &val, bool &isnull=BindOutInterface::notnullconstant) |
Static Public Attributes | |
static bool | notnullconstant |
Protected Types | |
typedef gc_ptr< VBC > | _refT |
typedef std::vector < _refT > | _outparamt |
Protected Member Functions | |
void | _done () |
void | _start () |
void | real_bindout (oracleHandles &, const OCIStatementHandle &, const SQL::SQLStatement &) |
bool | fetch (oracleHandles &, const OCIStatementHandle &, const SQL::SQLStatement &) |
bool | _fetch (oracleHandles &, const OCIStatementHandle &, const SQL::SQLStatement &) |
void | finish (oracleHandles &, const OCIStatementHandle &, const SQL::SQLStatement &) |
void | validateBindOut (const SQL::SQLStatement &SQL) const |
VBC & | getOutParam (const unsigned int pos) |
void | setIterators () |
Protected Attributes | |
gc_ptr < SelectListMetaData > | _slmd |
gc_ptr < SelectListBuffer > | _slb |
_outparamt | _outparam |
_outparamt::const_iterator | _begin |
_outparamt::const_iterator | _end |
Friends | |
class | SelectListBuffer |
class | internal::registerFinish |
virtual void fatalmind::SQL::BindOut< VBC, CT >::bindout | ( | const unsigned int | pos, | |
char & | val, | |||
bool & | isnull = BindOutInterface::notnullconstant | |||
) | [inline, virtual, inherited] |
Specify where the output data of an select statement are to be stored.
You need to specify an place where the columns for an select statement are to be stored. After each fetch those variables will be propagated with the actual values received from the select statement. You can also specify a bool which will be used as indicator if the fatched column is NULL. If you omit this third, optional parameter an Exception will be thrown in case a fetched column is NULL.
pos | The column number to be bound. Numbering starts with the leftmost column at 0. | |
val | The variable which should contain the value of this column after the fetch. Each time a row is retrieved the according column value value will be available in that variable. The content of the variable will not be changed in case the column is NULL or the execution failed because of an exception. Exclusive access is expected, so there are no synchronization effords taken by the select commands. The variable must be availalbe throughout the whole time of execution. | |
isnull | The optional third argument specifies a bool variable which will be set to true if the fetched column is NULL or to false otherwise. You must supply this indicator variable if you might retrieve NULL for this column. Not supplying an indicator varaible will cause anIndicator variable required but not supplied. exception. Well, so if you are sure your result will never be NULL, it's save to not provide the third arguement. In case you were wrong, you will receive an exception. |
Implements fatalmind::SQL::BindOutInterface.