| TerraLib 4.1

- Main Page
- Related Pages
- Modules
- Namespaces
- Classes
- Files
- Examples

- Class List
- Class Index
- Class Hierarchy
- Class Members

Public Types | Public Member Functions
oracle::occi::Statement Class Reference

`#include <occiControl.h>`

List of all members.

## Public Types

enum | Status { UNPREPARED, PREPARED, RESULT_SET_AVAILABLE, UPDATE_COUNT_AVAILABLE, NEEDS_STREAM_DATA, STREAM_DATA_AVAILABLE }

## Public Member Functions

virtual | ~Statement ()
virtual void | setSQL (const OCCI_STD_NAMESPACE::string &sql)=0
virtual OCCI_STD_NAMESPACE::string | getSQL () const =0
virtual Status | execute (const OCCI_STD_NAMESPACE::string &sql="")=0
virtual ResultSet * | getResultSet ()=0
virtual unsigned int | getUpdateCount () const =0
virtual ResultSet * | executeQuery (const OCCI_STD_NAMESPACE::string &sql="")=0
virtual unsigned int | executeUpdate (const OCCI_STD_NAMESPACE::string &sql="")=0
virtual Status | status () const =0
virtual void | closeResultSet (ResultSet *resultSet)=0
virtual void | setPrefetchRowCount (unsigned int rowCount)=0
virtual void | setPrefetchMemorySize (unsigned int bytes)=0
virtual void | setAutoCommit (bool autoCommit)=0
virtual bool | getAutoCommit () const =0
virtual OCIStmt * | getOCIStatement () const =0
virtual void | setMaxParamSize (unsigned int paramIndex, unsigned int maxSize)=0
virtual unsigned int | getMaxParamSize (unsigned int paramIndex) const =0
virtual void | setNull (unsigned int paramIndex, Type type)=0
virtual void | setInt (unsigned int paramIndex, int x)=0
virtual void | setUInt (unsigned int paramIndex, unsigned int x)=0
virtual void | setFloat (unsigned int paramIndex, float x)=0
virtual void | setDouble (unsigned int paramIndex, double x)=0
virtual void | setNumber (unsigned int paramIndex, const Number &x)=0
virtual void | setString (unsigned int paramIndex, const OCCI_STD_NAMESPACE::string &x)=0
virtual void | setBytes (unsigned int paramIndex, const Bytes &x)=0
virtual void | setDate (unsigned int paramIndex, const Date &x)=0
virtual void | setTimestamp (unsigned int paramIndex, const Timestamp &x)=0
virtual void | setBlob (unsigned int paramIndex, const Blob &x)=0
virtual void | setClob (unsigned int paramIndex, const Clob &x)=0
virtual void | setBfile (unsigned int paramIndex, const Bfile &x)=0
virtual void | setIntervalYM (unsigned int paramIndex, const IntervalYM &x)=0
virtual void | setIntervalDS (unsigned int paramIndex, const IntervalDS &x)=0
virtual void | setRowid (unsigned int paramIndex, const Bytes &x)=0
virtual void | setRef (unsigned int paramIndex, const RefAny &x)=0
virtual void | setObject (unsigned int paramIndex, PObject *x)=0
virtual void | setDataBuffer (unsigned int paramIndex, void *buffer, Type type, sb4 size, ub2 *length, sb2 *ind=NULL, ub2 *rc=NULL)=0
virtual void | setDataBufferArray (unsigned int paramIndex, void *buffer, Type type, ub4 arraySize, ub4 *arrayLength, sb4 elementSize, ub2 *elementLength, sb2 *ind=NULL, ub2 *rc=NULL)=0
virtual void | setCharSet (unsigned int paramIndex, const OCCI_STD_NAMESPACE::string &charSet)=0
virtual OCCI_STD_NAMESPACE::string | getCharSet (unsigned int paramIndex) const =0
virtual void | setDatabaseNCHARParam (unsigned int paramIndex, bool isNCHAR)=0
virtual bool | getDatabaseNCHARParam (unsigned int paramIndex) const =0
virtual void | closeStream (Stream *stream)=0
virtual Stream * | getStream (unsigned int paramIndex)=0
virtual unsigned int | getCurrentStreamParam () const =0
virtual unsigned int | getCurrentStreamIteration () const =0
virtual void | setBinaryStreamMode (unsigned int colIndex, unsigned int size)=0
virtual void | setCharacterStreamMode (unsigned int colIndex, unsigned int size)=0
virtual void | setMaxIterations (unsigned int maxIterations)=0
virtual unsigned int | getMaxIterations () const =0
virtual void | addIteration ()=0
virtual unsigned int | getCurrentIteration () const =0
virtual Status | executeArrayUpdate (unsigned int arrayLength)=0
virtual void | registerOutParam (unsigned int paramIndex, Type type, unsigned int maxSize=0, const OCCI_STD_NAMESPACE::string &sqltype="")=0
virtual bool | isNull (unsigned int paramIndex) const =0
virtual bool | isTruncated (unsigned int paramIndex) const =0
virtual void | setErrorOnNull (unsigned int paramIndex, bool causeException)=0
virtual void | setErrorOnTruncate (unsigned int paramIndex, bool causeException)=0
virtual int | preTruncationLength (unsigned int paramIndex) const =0
virtual int | getInt (unsigned int paramIndex)=0
virtual unsigned int | getUInt (unsigned int paramIndex)=0
virtual float | getFloat (unsigned int paramIndex)=0
virtual double | getDouble (unsigned int paramIndex)=0
virtual Number | getNumber (unsigned int paramIndex)=0
virtual OCCI_STD_NAMESPACE::string | getString (unsigned int paramIndex)=0
virtual Bytes | getBytes (unsigned int paramIndex)=0
virtual Date | getDate (unsigned int paramIndex)=0
virtual Timestamp | getTimestamp (unsigned int paramIndex)=0
virtual Bytes | getRowid (unsigned int paramIndex)=0
virtual PObject * | getObject (unsigned int paramIndex)=0
virtual Blob | getBlob (unsigned int paramIndex)=0
virtual Clob | getClob (unsigned int paramIndex)=0
virtual Bfile | getBfile (unsigned int paramIndex)=0
virtual IntervalYM | getIntervalYM (unsigned int paramIndex)=0
virtual IntervalDS | getIntervalDS (unsigned int paramIndex)=0
virtual RefAny | getRef (unsigned int paramIndex)=0
virtual ResultSet * | getCursor (unsigned int paramIndex)=0
virtual Connection * | getConnection () const =0
virtual void | setRef (unsigned int paramIndex, const RefAny &x, const OCCI_STD_NAMESPACE::string &typName, const OCCI_STD_NAMESPACE::string &schName="")=0
virtual void | setSQLUString (const UString &sql)=0
virtual UString | getSQLUString () const =0
virtual Status | execute (const UString &sql)=0
virtual ResultSet * | executeQuery (const UString &sql)=0
virtual unsigned int | executeUpdate (const UString &sql)=0
virtual void | setBFloat (unsigned int paramIndex, const BFloat &fval)=0
virtual void | setBDouble (unsigned int paramIndex, const BDouble &dval)=0
virtual void | setUString (unsigned int paramIndex, const UString &x)=0
virtual void | setCharSetUString (unsigned int paramIndex, const UString &charSet)=0
virtual UString | getCharSetUString (unsigned int paramIndex) const =0
virtual void | registerOutParam (unsigned int paramIndex, Type type, unsigned int maxSize, const OCCI_STD_NAMESPACE::string &typName, const OCCI_STD_NAMESPACE::string &schName)=0
virtual void | registerOutParam (unsigned int paramIndex, Type type, unsigned int maxSize, const UString &typName, const UString &schName)=0
virtual BFloat | getBFloat (unsigned int paramIndex)=0
virtual BDouble | getBDouble (unsigned int paramIndex)=0
virtual UString | getUString (unsigned int paramIndex)=0
virtual void | disableCaching ()=0
virtual void | setRef (unsigned int paramIndex, const RefAny &x, const UString &typName, const UString &schName)=0
virtual void | setBinaryStreamMode (unsigned int colIndex, unsigned int size, bool INArg)=0
virtual void | setCharacterStreamMode (unsigned int colIndex, unsigned int size, bool INArg)=0

## Member Enumeration Documentation

enum oracle::occi::Statement::Status

Enumerator:

  UNPREPARED |
  PREPARED |
  RESULT_SET_AVAILABLE |
  UPDATE_COUNT_AVAILABLE |
  NEEDS_STREAM_DATA |
  STREAM_DATA_AVAILABLE |

## Constructor & Destructor Documentation

virtual oracle::occi::Statement::~Statement | ( |  | ) | `[inline, virtual]`

## Member Function Documentation

virtual void oracle::occi::Statement::addIteration | ( |  | ) | `[pure virtual]`

virtual void oracle::occi::Statement::closeResultSet | ( | ResultSet * | resultSet | ) | `[pure virtual]`

virtual void oracle::occi::Statement::closeStream | ( | Stream * | stream | ) | `[pure virtual]`

virtual void oracle::occi::Statement::disableCaching | ( |  | ) | `[pure virtual]`

virtual Status oracle::occi::Statement::execute | ( | const UString & | sql | ) | `[pure virtual]`

virtual Status oracle::occi::Statement::execute | ( | const OCCI_STD_NAMESPACE::string & | sql = `""` | ) | `[pure virtual]`

virtual Status oracle::occi::Statement::executeArrayUpdate | ( | unsigned int | arrayLength | ) | `[pure virtual]`

virtual ResultSet* oracle::occi::Statement::executeQuery | ( | const UString & | sql | ) | `[pure virtual]`

virtual ResultSet* oracle::occi::Statement::executeQuery | ( | const OCCI_STD_NAMESPACE::string & | sql = `""` | ) | `[pure virtual]`

virtual unsigned int oracle::occi::Statement::executeUpdate | ( | const UString & | sql | ) | `[pure virtual]`

virtual unsigned int oracle::occi::Statement::executeUpdate | ( | const OCCI_STD_NAMESPACE::string & | sql = `""` | ) | `[pure virtual]`

virtual bool oracle::occi::Statement::getAutoCommit | ( |  | ) | const`[pure virtual]`

virtual BDouble oracle::occi::Statement::getBDouble | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual Bfile oracle::occi::Statement::getBfile | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual BFloat oracle::occi::Statement::getBFloat | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual Blob oracle::occi::Statement::getBlob | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual Bytes oracle::occi::Statement::getBytes | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual OCCI_STD_NAMESPACE::string oracle::occi::Statement::getCharSet | ( | unsigned int | paramIndex | ) | const`[pure virtual]`

virtual UString oracle::occi::Statement::getCharSetUString | ( | unsigned int | paramIndex | ) | const`[pure virtual]`

virtual Clob oracle::occi::Statement::getClob | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual Connection* oracle::occi::Statement::getConnection | ( |  | ) | const`[pure virtual]`

virtual unsigned int oracle::occi::Statement::getCurrentIteration | ( |  | ) | const`[pure virtual]`

virtual unsigned int oracle::occi::Statement::getCurrentStreamIteration | ( |  | ) | const`[pure virtual]`

virtual unsigned int oracle::occi::Statement::getCurrentStreamParam | ( |  | ) | const`[pure virtual]`

virtual ResultSet* oracle::occi::Statement::getCursor | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual bool oracle::occi::Statement::getDatabaseNCHARParam | ( | unsigned int | paramIndex | ) | const`[pure virtual]`

virtual Date oracle::occi::Statement::getDate | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual double oracle::occi::Statement::getDouble | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual float oracle::occi::Statement::getFloat | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual int oracle::occi::Statement::getInt | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual IntervalDS oracle::occi::Statement::getIntervalDS | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual IntervalYM oracle::occi::Statement::getIntervalYM | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual unsigned int oracle::occi::Statement::getMaxIterations | ( |  | ) | const`[pure virtual]`

virtual unsigned int oracle::occi::Statement::getMaxParamSize | ( | unsigned int | paramIndex | ) | const`[pure virtual]`

virtual Number oracle::occi::Statement::getNumber | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual PObject* oracle::occi::Statement::getObject | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual OCIStmt* oracle::occi::Statement::getOCIStatement | ( |  | ) | const`[pure virtual]`

virtual RefAny oracle::occi::Statement::getRef | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual ResultSet* oracle::occi::Statement::getResultSet | ( |  | ) | `[pure virtual]`

virtual Bytes oracle::occi::Statement::getRowid | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual OCCI_STD_NAMESPACE::string oracle::occi::Statement::getSQL | ( |  | ) | const`[pure virtual]`

virtual UString oracle::occi::Statement::getSQLUString | ( |  | ) | const`[pure virtual]`

virtual Stream* oracle::occi::Statement::getStream | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual OCCI_STD_NAMESPACE::string oracle::occi::Statement::getString | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual Timestamp oracle::occi::Statement::getTimestamp | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual unsigned int oracle::occi::Statement::getUInt | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual unsigned int oracle::occi::Statement::getUpdateCount | ( |  | ) | const`[pure virtual]`

virtual UString oracle::occi::Statement::getUString | ( | unsigned int | paramIndex | ) | `[pure virtual]`

virtual bool oracle::occi::Statement::isNull | ( | unsigned int | paramIndex | ) | const`[pure virtual]`

virtual bool oracle::occi::Statement::isTruncated | ( | unsigned int | paramIndex | ) | const`[pure virtual]`

virtual int oracle::occi::Statement::preTruncationLength | ( | unsigned int | paramIndex | ) | const`[pure virtual]`

virtual void oracle::occi::Statement::registerOutParam | ( | unsigned int | paramIndex,
|  | Type | type,
|  | unsigned int | maxSize,
|  | const UString & | typName,
|  | const UString & | schName
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::registerOutParam | ( | unsigned int | paramIndex,
|  | Type | type,
|  | unsigned int | maxSize,
|  | const OCCI_STD_NAMESPACE::string & | typName,
|  | const OCCI_STD_NAMESPACE::string & | schName
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::registerOutParam | ( | unsigned int | paramIndex,
|  | Type | type,
|  | unsigned int | maxSize = `0`,
|  | const OCCI_STD_NAMESPACE::string & | sqltype = `""`
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setAutoCommit | ( | bool | autoCommit | ) | `[pure virtual]`

virtual void oracle::occi::Statement::setBDouble | ( | unsigned int | paramIndex,
|  | const BDouble & | dval
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setBfile | ( | unsigned int | paramIndex,
|  | const Bfile & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setBFloat | ( | unsigned int | paramIndex,
|  | const BFloat & | fval
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setBinaryStreamMode | ( | unsigned int | colIndex,
|  | unsigned int | size,
|  | bool | INArg
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setBinaryStreamMode | ( | unsigned int | colIndex,
|  | unsigned int | size
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setBlob | ( | unsigned int | paramIndex,
|  | const Blob & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setBytes | ( | unsigned int | paramIndex,
|  | const Bytes & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setCharacterStreamMode | ( | unsigned int | colIndex,
|  | unsigned int | size
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setCharacterStreamMode | ( | unsigned int | colIndex,
|  | unsigned int | size,
|  | bool | INArg
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setCharSet | ( | unsigned int | paramIndex,
|  | const OCCI_STD_NAMESPACE::string & | charSet
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setCharSetUString | ( | unsigned int | paramIndex,
|  | const UString & | charSet
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setClob | ( | unsigned int | paramIndex,
|  | const Clob & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setDatabaseNCHARParam | ( | unsigned int | paramIndex,
|  | bool | isNCHAR
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setDataBuffer | ( | unsigned int | paramIndex,
|  | void * | buffer,
|  | Type | type,
|  | sb4 | size,
|  | ub2 * | length,
|  | sb2 * | ind = `NULL`,
|  | ub2 * | rc = `NULL`
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setDataBufferArray | ( | unsigned int | paramIndex,
|  | void * | buffer,
|  | Type | type,
|  | ub4 | arraySize,
|  | ub4 * | arrayLength,
|  | sb4 | elementSize,
|  | ub2 * | elementLength,
|  | sb2 * | ind = `NULL`,
|  | ub2 * | rc = `NULL`
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setDate | ( | unsigned int | paramIndex,
|  | const Date & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setDouble | ( | unsigned int | paramIndex,
|  | double | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setErrorOnNull | ( | unsigned int | paramIndex,
|  | bool | causeException
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setErrorOnTruncate | ( | unsigned int | paramIndex,
|  | bool | causeException
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setFloat | ( | unsigned int | paramIndex,
|  | float | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setInt | ( | unsigned int | paramIndex,
|  | int | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setIntervalDS | ( | unsigned int | paramIndex,
|  | const IntervalDS & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setIntervalYM | ( | unsigned int | paramIndex,
|  | const IntervalYM & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setMaxIterations | ( | unsigned int | maxIterations | ) | `[pure virtual]`

virtual void oracle::occi::Statement::setMaxParamSize | ( | unsigned int | paramIndex,
|  | unsigned int | maxSize
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setNull | ( | unsigned int | paramIndex,
|  | Type | type
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setNumber | ( | unsigned int | paramIndex,
|  | const Number & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setObject | ( | unsigned int | paramIndex,
|  | PObject * | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setPrefetchMemorySize | ( | unsigned int | bytes | ) | `[pure virtual]`

virtual void oracle::occi::Statement::setPrefetchRowCount | ( | unsigned int | rowCount | ) | `[pure virtual]`

virtual void oracle::occi::Statement::setRef | ( | unsigned int | paramIndex,
|  | const RefAny & | x,
|  | const OCCI_STD_NAMESPACE::string & | typName,
|  | const OCCI_STD_NAMESPACE::string & | schName = `""`
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setRef | ( | unsigned int | paramIndex,
|  | const RefAny & | x,
|  | const UString & | typName,
|  | const UString & | schName
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setRef | ( | unsigned int | paramIndex,
|  | const RefAny & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setRowid | ( | unsigned int | paramIndex,
|  | const Bytes & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setSQL | ( | const OCCI_STD_NAMESPACE::string & | sql | ) | `[pure virtual]`

virtual void oracle::occi::Statement::setSQLUString | ( | const UString & | sql | ) | `[pure virtual]`

virtual void oracle::occi::Statement::setString | ( | unsigned int | paramIndex,
|  | const OCCI_STD_NAMESPACE::string & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setTimestamp | ( | unsigned int | paramIndex,
|  | const Timestamp & | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setUInt | ( | unsigned int | paramIndex,
|  | unsigned int | x
| ) |  | `[pure virtual]`

virtual void oracle::occi::Statement::setUString | ( | unsigned int | paramIndex,
|  | const UString & | x
| ) |  | `[pure virtual]`

virtual Status oracle::occi::Statement::status | ( |  | ) | const`[pure virtual]`

The documentation for this class was generated from the following file:

- E:/Projetos_Primeiro_Semestre_2012/TerraView/terralib/src/terralib/drivers/Oracle/OCI/include/occiControl.h

All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Defines