library: libOracle
#include "TOracleStatement.h"

TOracleStatement


class description - header file - source file
viewCVS header - viewCVS source

class TOracleStatement: public TSQLStatement

Inheritance Inherited Members Includes Libraries
Class Charts

Function Members (Methods)

Display options:
Show inherited
Show non-public
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 = "")
virtual Int_tTObject::DistancetoPrimitive(Int_t px, Int_t py)
virtual voidTObject::Draw(Option_t* option = "")
virtual voidTObject::DrawClass() const
virtual TObject*TObject::DrawClone(Option_t* option = "") const
virtual voidTObject::Dump() const
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
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() const
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 = "") const
virtual voidTObject::SavePrimitive(ostream& 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 = "")
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_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 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

public:
enum TObject::EStatusBits { kCanDelete
kMustCleanup
kObjInCanvas
kIsReferenced
kHasUUID
kCannotPick
kNoContextMenu
kInvalidObject
};
enum TObject::[unnamed] { kIsOnHeap
kNotDeleted
kZombie
kBitMask
kSingleKey
kOverwrite
kWriteDelete
};
protected:
Environment*fEnvenviroment
Connection*fConnconnection to Oracle
Statement*fStmtexecuted statement
ResultSet*fResultquery result (rows)
vector<MetaData>*fFieldInfoinfo for each field in the row
TOracleStatement::TBufferRec*fBufferbuffer of values and field names
Int_tfBufferSizesize of fBuffer
Int_tfNumIterationssize of internal statement buffer
Int_tfIterCountercounts nextiteration calls and process iterations, if required
Int_tfWorkingMode1 - settingpars, 2 - getting results
TStringfTimeFmtformat for date to string conversion, default "MM/DD/YYYY, HH24:MI:SS"
Int_tTSQLStatement::fErrorCodeerror code of last operation
TStringTSQLStatement::fErrorMsgerror message of last operation
Bool_tTSQLStatement::fErrorOutenable error output

Class Description

                                                                      
  SQL statement class for Oracle                                      
                                                                      
  See TSQLStatement class documentation for more details.             
                                                                      

TOracleStatement(Environment* env, Connection* conn, Statement* stmt, Int_t niter, Bool_t errout)
 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)
 Set string value for parameter npar
Bool_t SetBinary(Int_t npar, void* mem, Long_t size, Long_t maxsize)
 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)
 Set date & time value 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 
Int_t GetNumFields()
 Returns number of fields in result set 
const char* GetFieldName(Int_t npar)
 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 npar)
 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 
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 IsParSettMode()
{ return fWorkingMode==1; }
Bool_t IsResultSet()
{ return (fWorkingMode==2) && (fResult!=0); }
TOracleStatement(Environment* env, Connection* conn, Statement* stmt, Int_t niter, Bool_t errout = kTRUE)
Int_t GetBufferLength()
{ return fNumIterations; }
void SetTimeFormating(const char* fmt)
{ fTimeFmt = fmt; }

Author: Sergey Linev 6/02/2006
Last update: root/oracle:$Name: $:$Id: TOracleStatement.cxx,v 1.6 2006/09/05 13:37:08 brun Exp $
Copyright (C) 1995-2006, Rene Brun and Fons Rademakers. *


ROOT page - Class index - Class Hierarchy - Top of the page

This page has been automatically generated. If you have any comments or suggestions about the page layout send a mail to ROOT support, or contact the developers with any questions or problems regarding ROOT.