ROOT logo
ROOT » SQL » ORACLE » TOracleStatement

class TOracleStatement: public TSQLStatement


SQL statement class for Oracle

See TSQLStatement class documentation for more details.


Function Members (Methods)

public:
TOracleStatement(const TOracleStatement&)
TOracleStatement(Environment* env, Connection* conn, Statement* stmt, Int_t niter, Bool_t errout = kTRUE)
virtual~TOracleStatement()
voidTObject::AbstractMethod(const char* method) const
virtual voidTObject::AppendPad(Option_t* option = "")
virtual voidTObject::Browse(TBrowser* b)
static TClass*Class()
virtual const char*TObject::ClassName() const
virtual voidTObject::Clear(Option_t* = "")
virtual TObject*TObject::Clone(const char* newname = "") const
virtual voidClose(Option_t* = "")
virtual Int_tTObject::Compare(const TObject* obj) const
virtual voidTObject::Copy(TObject& object) const
virtual voidTObject::Delete(Option_t* option = "")MENU
virtual Int_tTObject::DistancetoPrimitive(Int_t px, Int_t py)
virtual voidTObject::Draw(Option_t* option = "")
virtual voidTObject::DrawClass() constMENU
virtual TObject*TObject::DrawClone(Option_t* option = "") constMENU
virtual voidTObject::Dump() constMENU
virtual voidTSQLStatement::EnableErrorOutput(Bool_t on = kTRUE)
virtual voidTObject::Error(const char* method, const char* msgfmt) const
virtual voidTObject::Execute(const char* method, const char* params, Int_t* error = 0)
virtual voidTObject::Execute(TMethod* method, TObjArray* params, Int_t* error = 0)
virtual voidTObject::ExecuteEvent(Int_t event, Int_t px, Int_t py)
virtual voidTObject::Fatal(const char* method, const char* msgfmt) const
virtual TObject*TObject::FindObject(const char* name) const
virtual TObject*TObject::FindObject(const TObject* obj) const
virtual Bool_tGetBinary(Int_t npar, void*& mem, Long_t& size)
virtual Int_tGetBufferLength() const
virtual Bool_tGetDate(Int_t npar, Int_t& year, Int_t& month, Int_t& day)
virtual Bool_tGetDatime(Int_t npar, Int_t& year, Int_t& month, Int_t& day, Int_t& hour, Int_t& min, Int_t& sec)
Int_tTSQLStatement::GetDay(Int_t)
virtual Double_tGetDouble(Int_t npar)
virtual Option_t*TObject::GetDrawOption() const
static Long_tTObject::GetDtorOnly()
virtual Int_tTSQLStatement::GetErrorCode() const
virtual const char*TSQLStatement::GetErrorMsg() const
virtual const char*GetFieldName(Int_t nfield)
Int_tTSQLStatement::GetHour(Int_t)
virtual const char*TObject::GetIconName() const
virtual Int_tGetInt(Int_t npar)
virtual Long_tGetLong(Int_t npar)
virtual Long64_tGetLong64(Int_t npar)
Int_tTSQLStatement::GetMinute(Int_t)
Int_tTSQLStatement::GetMonth(Int_t)
virtual const char*TObject::GetName() const
virtual Int_tGetNumAffectedRows()
virtual Int_tGetNumFields()
virtual Int_tGetNumParameters()
virtual char*TObject::GetObjectInfo(Int_t px, Int_t py) const
static Bool_tTObject::GetObjectStat()
virtual Option_t*TObject::GetOption() const
Int_tTSQLStatement::GetSecond(Int_t)
virtual const char*GetString(Int_t npar)
virtual Bool_tGetTime(Int_t npar, Int_t& hour, Int_t& min, Int_t& sec)
virtual Bool_tGetTimestamp(Int_t npar, Int_t& year, Int_t& month, Int_t& day, Int_t& hour, Int_t& min, Int_t& sec, Int_t& frac)
virtual const char*TObject::GetTitle() const
virtual UInt_tGetUInt(Int_t npar)
virtual ULong64_tGetULong64(Int_t npar)
virtual UInt_tTObject::GetUniqueID() const
virtual Bool_tGetVDouble(Int_t npar, vector<Double_t>& value)
virtual Bool_tGetVInt(Int_t npar, vector<Int_t>& value)
virtual Bool_tGetVLong(Int_t npar, vector<Long_t>& value)
virtual Bool_tGetVLong64(Int_t npar, vector<Long64_t>& value)
virtual Bool_tGetVUInt(Int_t npar, vector<UInt_t>& value)
virtual Bool_tGetVULong64(Int_t npar, vector<ULong64_t>& value)
Int_tTSQLStatement::GetYear(Int_t)
virtual Bool_tTObject::HandleTimer(TTimer* timer)
virtual ULong_tTObject::Hash() const
virtual voidTObject::Info(const char* method, const char* msgfmt) const
virtual Bool_tTObject::InheritsFrom(const char* classname) const
virtual Bool_tTObject::InheritsFrom(const TClass* cl) const
virtual voidTObject::Inspect() constMENU
voidTObject::InvertBit(UInt_t f)
virtual TClass*IsA() const
virtual Bool_tTObject::IsEqual(const TObject* obj) const
virtual Bool_tTSQLStatement::IsError() const
virtual Bool_tTObject::IsFolder() const
virtual Bool_tIsNull(Int_t)
Bool_tTObject::IsOnHeap() const
virtual Bool_tTObject::IsSortable() const
Bool_tTObject::IsZombie() const
virtual voidTObject::ls(Option_t* option = "") const
voidTObject::MayNotUse(const char* method) const
virtual Bool_tNextIteration()
virtual Bool_tNextResultRow()
virtual Bool_tTObject::Notify()
static voidTObject::operator delete(void* ptr)
static voidTObject::operator delete(void* ptr, void* vp)
static voidTObject::operator delete[](void* ptr)
static voidTObject::operator delete[](void* ptr, void* vp)
void*TObject::operator new(size_t sz)
void*TObject::operator new(size_t sz, void* vp)
void*TObject::operator new[](size_t sz)
void*TObject::operator new[](size_t sz, void* vp)
TOracleStatement&operator=(const TOracleStatement&)
virtual voidTObject::Paint(Option_t* option = "")
virtual voidTObject::Pop()
virtual voidTObject::Print(Option_t* option = "") const
virtual Bool_tProcess()
virtual Int_tTObject::Read(const char* name)
virtual voidTObject::RecursiveRemove(TObject* obj)
voidTObject::ResetBit(UInt_t f)
virtual voidTObject::SaveAs(const char* filename = "", Option_t* option = "") constMENU
virtual voidTObject::SavePrimitive(basic_ostream<char,char_traits<char> >& out, Option_t* option = "")
virtual Bool_tSetBinary(Int_t npar, void* mem, Long_t size, Long_t maxsize = 0x1000)
voidTObject::SetBit(UInt_t f)
voidTObject::SetBit(UInt_t f, Bool_t set)
virtual Bool_tSetDate(Int_t npar, Int_t year, Int_t month, Int_t day)
virtual Bool_tSetDatime(Int_t npar, Int_t year, Int_t month, Int_t day, Int_t hour, Int_t min, Int_t sec)
virtual Bool_tSetDouble(Int_t npar, Double_t value)
virtual voidTObject::SetDrawOption(Option_t* option = "")MENU
static voidTObject::SetDtorOnly(void* obj)
virtual Bool_tSetInt(Int_t npar, Int_t value)
virtual Bool_tSetLong(Int_t npar, Long_t value)
virtual Bool_tSetLong64(Int_t npar, Long64_t value)
virtual Bool_tSetMaxFieldSize(Int_t nfield, Long_t maxsize)
virtual Bool_tSetNull(Int_t npar)
static voidTObject::SetObjectStat(Bool_t stat)
virtual Bool_tSetString(Int_t npar, const char* value, Int_t maxsize = 256)
virtual Bool_tSetTime(Int_t npar, Int_t hour, Int_t min, Int_t sec)
virtual voidSetTimeFormating(const char* fmt)
virtual Bool_tSetTimestamp(Int_t npar, Int_t year, Int_t month, Int_t day, Int_t hour, Int_t min, Int_t sec, Int_t frac = 0)
virtual Bool_tSetUInt(Int_t npar, UInt_t value)
virtual Bool_tSetULong64(Int_t npar, ULong64_t value)
virtual voidTObject::SetUniqueID(UInt_t uid)
virtual Bool_tSetVDouble(Int_t npar, const vector<Double_t> value, const char* schemaName, const char* typeName)
virtual Bool_tSetVInt(Int_t npar, const vector<Int_t> value, const char* schemaName, const char* typeName)
virtual Bool_tSetVLong(Int_t npar, const vector<Long_t> value, const char* schemaName, const char* typeName)
virtual Bool_tSetVLong64(Int_t npar, const vector<Long64_t> value, const char* schemaName, const char* typeName)
virtual Bool_tSetVUInt(Int_t npar, const vector<UInt_t> value, const char* schemaName, const char* typeName)
virtual Bool_tSetVULong64(Int_t npar, const vector<ULong64_t> value, const char* schemaName, const char* typeName)
virtual voidShowMembers(TMemberInspector& insp, char* parent)
virtual Bool_tStoreResult()
virtual voidStreamer(TBuffer& b)
voidStreamerNVirtual(TBuffer& b)
virtual voidTObject::SysError(const char* method, const char* msgfmt) const
Bool_tTObject::TestBit(UInt_t f) const
Int_tTObject::TestBits(UInt_t f) const
virtual voidTObject::UseCurrentStyle()
virtual voidTObject::Warning(const char* method, const char* msgfmt) const
virtual Int_tTObject::Write(const char* name = 0, Int_t option = 0, Int_t bufsize = 0)
virtual Int_tTObject::Write(const char* name = 0, Int_t option = 0, Int_t bufsize = 0) const
protected:
voidTSQLStatement::ClearError()
voidCloseBuffer()
virtual voidTObject::DoError(int level, const char* location, const char* fmt, va_list va) const
Bool_tIsParSettMode() const
Bool_tIsResultSet() const
voidTObject::MakeZombie()
voidSetBufferSize(Int_t size)
voidTSQLStatement::SetError(Int_t code, const char* msg, const char* method = 0)

Data Members

protected:
TOracleStatement::TBufferRec*fBufferbuffer of values and field names
Int_tfBufferSizesize of fBuffer
Connection*fConnconnection to Oracle
Environment*fEnvenviroment
Int_tTSQLStatement::fErrorCodeerror code of last operation
TStringTSQLStatement::fErrorMsgerror message of last operation
Bool_tTSQLStatement::fErrorOutenable error output
vector<MetaData>*fFieldInfoinfo for each field in the row
Int_tfIterCountercounts nextiteration calls and process iterations, if required
Int_tfNumIterationssize of internal statement buffer
ResultSet*fResultquery result (rows)
Statement*fStmtexecuted statement
TStringfTimeFmtformat for date to string conversion, default "MM/DD/YYYY, HH24:MI:SS"
Int_tfWorkingMode1 - settingpars, 2 - getting results

Class Charts

Inheritance Inherited Members Includes Libraries
Class Charts

Function documentation

TOracleStatement(Environment* env, Connection* conn, Statement* stmt, Int_t niter, Bool_t errout = kTRUE)
 Normal constructor of TOracleStatement class
 On creation time specifies buffer length, which should be
 used in data fetching or data inserting
~TOracleStatement()
 Destructor of TOracleStatement clas
void Close(Option_t* = "")
 Close Oracle statement
 Removes and destroys all buffers and metainfo
void SetBufferSize(Int_t size)
 Set buffer size, which is used to keep string values of
 currently fetched column.
void CloseBuffer()
 Destroy buffers, used in data fetching
Bool_t Process()
 Process SQL statement
Int_t GetNumAffectedRows()
 Return number of affected rows after statement Process() was called
 Make sense for queries like SELECT, INSERT, UPDATE
Int_t GetNumParameters()
 Return number of parameters in statement
 Not yet implemented for Oracle
Bool_t SetNull(Int_t npar)
 Set NULL as value of parameter npar
Bool_t SetInt(Int_t npar, Int_t value)
 Set integer value for parameter npar
Bool_t SetUInt(Int_t npar, UInt_t value)
 Set unsigned integer value for parameter npar
Bool_t SetLong(Int_t npar, Long_t value)
 Set long integer value for parameter npar
Bool_t SetLong64(Int_t npar, Long64_t value)
 Set 64-bit integer value for parameter npar
Bool_t SetULong64(Int_t npar, ULong64_t value)
 Set unsigned 64-bit integer value for parameter npar
Bool_t SetDouble(Int_t npar, Double_t value)
 Set double value for parameter npar
Bool_t SetString(Int_t npar, const char* value, Int_t maxsize = 256)
 Set string value for parameter npar
Bool_t SetBinary(Int_t npar, void* mem, Long_t size, Long_t maxsize = 0x1000)
 set parameter value as binary data
Bool_t SetDate(Int_t npar, Int_t year, Int_t month, Int_t day)
 Set date value for parameter npar
Bool_t SetTime(Int_t npar, Int_t hour, Int_t min, Int_t sec)
 Set time value for parameter npar
Bool_t SetDatime(Int_t npar, Int_t year, Int_t month, Int_t day, Int_t hour, Int_t min, Int_t sec)
 Set date & time value for parameter npar
Bool_t SetTimestamp(Int_t npar, Int_t year, Int_t month, Int_t day, Int_t hour, Int_t min, Int_t sec, Int_t frac = 0)
 Set date & time value for parameter npar
Bool_t SetVInt(Int_t npar, const vector<Int_t> value, const char* schemaName, const char* typeName)
 Set vector of integer values for parameter npar
Bool_t SetVUInt(Int_t npar, const vector<UInt_t> value, const char* schemaName, const char* typeName)
 Set vector of unsigned integer values for parameter npar
Bool_t SetVLong(Int_t npar, const vector<Long_t> value, const char* schemaName, const char* typeName)
 Set vector of long integer values for parameter npar
Bool_t SetVLong64(Int_t npar, const vector<Long64_t> value, const char* schemaName, const char* typeName)
 Set vector of 64-bit integer values for parameter npar
Bool_t SetVULong64(Int_t npar, const vector<ULong64_t> value, const char* schemaName, const char* typeName)
 Set vector of unsigned 64-bit integer values for parameter npar
Bool_t SetVDouble(Int_t npar, const vector<Double_t> value, const char* schemaName, const char* typeName)
 Set vector of double values for parameter npar
Bool_t NextIteration()
 Add next iteration for statement with parameters
Bool_t StoreResult()
 Store result of statement processing.
 Required to access results of SELECT queries
Bool_t SetMaxFieldSize(Int_t nfield, Long_t maxsize)
 Defines maximum size for field which must be used for read or write operation
 Some Oracle types as LONG (long binary continer) requires this call
 before any data can be read from database. Call it once before first call to NextResultRow()
Int_t GetNumFields()
 Returns number of fields in result set
const char* GetFieldName(Int_t nfield)
 Return field name in result set
Bool_t NextResultRow()
 Move cursor to next row in result set.
 For Oracle it may lead to additional request to database
Bool_t IsNull(Int_t )
 Checks if fieled value in result set is NULL
Int_t GetInt(Int_t npar)
 return field value as integer
UInt_t GetUInt(Int_t npar)
 return field value as unsigned integer
Long_t GetLong(Int_t npar)
 return field value as long integer
Long64_t GetLong64(Int_t npar)
 return field value as 64-bit integer
ULong64_t GetULong64(Int_t npar)
 return field value as unsigned 64-bit integer
Double_t GetDouble(Int_t npar)
 return field value as double
const char* GetString(Int_t npar)
 return field value as string
Bool_t GetBinary(Int_t npar, void*& mem, Long_t& size)
 Return field value as binary array
 Supports LONG, BLOB, CLOB, BFILE, CFILE types of columns
 Reads complete content of the column, therefore not suitable for
 big structures
Bool_t GetDate(Int_t npar, Int_t& year, Int_t& month, Int_t& day)
 return field value as date
Bool_t GetTime(Int_t npar, Int_t& hour, Int_t& min, Int_t& sec)
 return field value as time
Bool_t GetDatime(Int_t npar, Int_t& year, Int_t& month, Int_t& day, Int_t& hour, Int_t& min, Int_t& sec)
 return field value as date & time
Bool_t GetTimestamp(Int_t npar, Int_t& year, Int_t& month, Int_t& day, Int_t& hour, Int_t& min, Int_t& sec, Int_t& frac)
 return field value as date & time
Bool_t GetVInt(Int_t npar, vector<Int_t>& value)
 return field value as vector of integers
Bool_t GetVUInt(Int_t npar, vector<UInt_t>& value)
 return field value as vector of unsigned integers
Bool_t GetVLong(Int_t npar, vector<Long_t>& value)
 return field value as vector of long integers
Bool_t GetVLong64(Int_t npar, vector<Long64_t>& value)
 return field value as vector of 64-bit integers
Bool_t GetVULong64(Int_t npar, vector<ULong64_t>& value)
 return field value as vector of unsigned 64-bit integers
Bool_t GetVDouble(Int_t npar, vector<Double_t>& value)
 return field value as vector of doubles
Bool_t IsParSettMode() const
{ return fWorkingMode==1; }
Bool_t IsResultSet() const
{ return (fWorkingMode==2) && (fResult!=0); }
TOracleStatement(Environment* env, Connection* conn, Statement* stmt, Int_t niter, Bool_t errout = kTRUE)
Int_t GetBufferLength() const
{ return fNumIterations; }
void SetTimeFormating(const char* fmt)
{ fTimeFmt = fmt; }